Maintaining Uniqueness with Clustered ColumnStore Index | SQL Server 2014

Column Store indexes were introduced in SQL Server 2012 with a flavor of Non-Clustered index i.e. “Non-Clustered ColumnStore” index. However there is a big limitation that the underlying table becomes read-only as soon as you create one. In SQL Server 2014 this behavior is unchanged and addition to this you can also create ColumnStore index as a Clustered index. And the good thing…


Top SQL Blogs – Windows 8 App | from MSDN, MVPs and Top Bloggers

After I published my first App [SQL with Manoj] on Windows 8 Store, I thought to create an another App at a broader level, which will cover latest SQL Server and TSQL topics from MSDN blogs, MVPs and other famous Bloggers, like Paul S. Randal, Kimberly Trip, Sam Lester, Brent Ozar, etc. And today I’m very happy to…

1

Another reason to use THROW clause instead of RAISERROR

In my previous post [link] I talked about the new THROW clause introduced in SQL Server 2012 and how it is different from the existing RAISERROR function. I just stumbled on one more reason to stop using RAISERROR function and start using the new THROW clause. There are some SQL statements that throws more than…

1