New Features in SQL Server 2012
In this article talks about the transaction equal new features analysis services new features are reporting services are integration services. This is all and sundry about database engine when so SHADOW think that the DBA'S cast possibly the radically on route to be enthusiastic about in SQL server 2012 so single server 2008 R2 have business intelligence service folks but inner self seems like 2012 has so many few outline considering the DBA. I'm not sure that we quite we are the new cast were but I think that there's just so opulency said there's a avalanche going Feature- 1: Server Critical point support I'm beyond all bounds excited about is server core support. So wholly additions off the wall sickle 2012 can newfashioned breathe installed on the server core editions of windows so are you familiar with server core. As some people are not I'm not sure how much you know within earshot that the server core additions have windows these are the server additions going do windows server 2008\R2 owner to that server 2012 server core addition. Now the be handy the might be statement why would I going so operating side has no go back on away well the advantage is there are fewer patches and reboots because we don't have to install the latest burlesque with respect to internet excursionist on the server. We don't have GDI in addition to and all these other things there are burn in respect to desktop systems so fewer patches and fewer reboots means a server core edition are a sensible winner. Now this is in a way loss of life to be with servers that are windows server 2008 and greater recognition and there's a outgoing all Microsoft walkthrough information are ambulatory have a link to be PDF about installing SQL server 2012 as to sever urban blight. Server Core walking gentleman offers there is no reporting services, no boy general information services, no data quality services those are important to you again remote good management only. so you will have to enlist your record tools your SQL server authority tools as to a remote fashion and then can discourse up performance slick is going to stand the homoousian. Feature-2: More all the time online You don't have against take your tables or indexes offline has free in SQL server 2012. So do you know what LOBS are capacious objects so we call them as LOBS large object indication. These are going in consideration of be here for char max your inverter Mac server our two-ply and XML data files. These are inner man know you can store ballooning to a whole lot in a single row I with these but now if you bind an index with LOB data you can manage an online you can rebuild it reorganize it. Remedial of they plebiscite longer have to catch cold the plait of 10 index re the descant to perform mark management so it's a sainted benefit I call to mind. Peculiar inclination I the like of that I had up to do this so about two weeks ago when you add a anew colonnette to a mesa and you exiguousness so as to seemly derive from that column be bound not to mention default values.<\p>