Monthly Archives: June 2014

Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance. Step 1 : Check Current Instance & host name Current Host Name : admin-0783e4076 Current SQL Instance Name : admin-0783e4076 Select @@ServerName ServerName, Host_name() HostName Step 2 : Rename Host name & reboot the server Step 3 : Try … Continue reading →

SQL Server 2014 – How to add features to existing instance ? :- 1) Start installation center 2) Run Global Rule, You need to fix if any failure occur 3) Microsoft update option (Enable windows updates to search & install SQL updates as well) 4) Include product update with installation, (the latest available SQL Server … Continue reading →

ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012 Microsoft release a fix for above issue and now available for download for SQL Server 2012SP2. Refer Article : http://support.microsoft.com/kb/2969896 Download Link : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2969896&kbln=en-us If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun … Continue reading →

Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below : A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. SQL Server 2012 helps user to isolate their database from the instance in … Continue reading →

ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) : “An xVelocity memory optimized ColumnStore index, groups and stores data for each column and then joins all the columns to complete the whole index. This differs from traditional indexes which group and store data for each row and then join all the … Continue reading →