Yearly Archives: 2014

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 →

Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning. Please keep liking us & providing your feedback for improvements. Visitors increasing day by day :- Visitors from all over the world :- Top 5 Pages :- http://mssqlfun.com/2012/11/05/sql-server-list-of-all-the-error-codes-or-messages/ http://mssqlfun.com/2013/01/09/the-execute-permission-was-denied-on-the-object-sp_start_job-database-msdb-schema-dbo/ http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/ http://mssqlfun.com/2013/01/15/the-server-principal-xxxx-is-not-able-to-access-the-database-msdb-under-the-current-security-context/ http://mssqlfun.com/2013/08/12/dmv-13-finding-locking-blocking-sys-dm_tran_locks/ Recent Posts :- http://mssqlfun.com/2014/06/12/sql-server-2012-service-pack-2-sp2-rtm-is-now-available/ … Continue reading →

SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack 2 contains all the hotfixes released since the initial release of SQL Server 2012 RTM. Whether You are facing issue in your environment or not, It’s Recommended to install in your environment. Download Link : … Continue reading →

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon. Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 about to end on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow, Critical bug fixes may be … Continue reading →