Category Archives: SQL Server 2014

Rebuild a Specific Partition

The following code snippet will enable you to rebuild a specific partition on an index in SQL Server. This is very useful when the table in question is very large and you only want to rebuild the specific partition that … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , , | 1 Comment

Clustered Columnstore Index in SQL Server 2014

The clustered columnstore index which shipped with SQL Server 2014 is busy revolutionizing the Data Warehousing landscape in SQL Server. When creating a Fact Table in a data warehouse you will almost without question put a Clustered Columnstore (CCI) on … Continue reading

Posted in SQL Server 2014 | Tagged , , , | Leave a comment

Partition Switching for Big Data Loads – Partition Switch Out

This is the last in a four part series of blog post explaining Partition Switching using SQL Server 2014. Before switching data into a specific partition we must first ensure the relevant partition is empty, otherwise the Partition Switch In … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , , | Leave a comment

SQL Server 2016 CTP 2

The first Public SQL Server 2016 Preview which is called SQL Server 2016 CTP2  is now available for download. Follow the link to the download site and get your copy. The following TechNet webpage will give you a brief overview … Continue reading

Posted in SQL Server 2014 | Tagged | 1 Comment

SQL Server SSMS Color Coded Status Bar

Have you ever experienced the nauseating feeling when running an update, delete or truncate statement thinking you are working on the development server while the connection is actually pointing to production database server in SQL Server Management Studio (SSMS). You … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment

Best Practices for Building a Large Scale Data Warehouse

You walk into the office today and your client, or your boss, asks you to build a warehouse. All seems fine and dandy, right. You are the developer and this should be easy. “O, and by the way, our 5 OLTP systems … Continue reading

Posted in SQL Server 2014 | Tagged , , | Leave a comment

SQL 2014 SP1 released

Microsoft has released Service Pack 1 for SQL Server 2014 , 14 May 2015. Why do you need it? The most obvious reason is, it is free! Secondly, there are some key fixes and improvements included in this release. Below … Continue reading

Posted in SQL Server 2014 | Tagged | Leave a comment