Monthly Archives: January 2016

SQL Cuppa Sessions

By | January 7, 2016

If you have been following me on LinkedIn recently you must have seen this update. Looking forward to having some fun SQL conversations, especially on what people think of SQL 2016 so far. One of the questions I have been asked is “How will we recognize you”? (I don’t have a lot of pics on… Read More »

Sample Script for Partitioning

By | January 5, 2016

First we create the database CREATE DATABASE PARTITIONSAMPLE GO — SET THE CONTEXT TO PARTITIONSAMPLE DATABASE USE PARTITIONSAMPLE GO — ALTER THE DATABASE TO ADD A NEW FILE GROUP , THIS ALLOWS US TO ADD ADDITIONAL DATA FILES WHICH IN TURN — WILL ALLOW THE DATABASE TO BE SPLIT OVER MULTIPLE DISK , REDUCNG DISK… Read More »

SQL 2016 – DATEDIFF_BIG

By | January 4, 2016

I don’t know about most guys out there but I personally feel this was a great addition to SQL 2016. I use the datetime2 function quite a bit when analyzing performance issues. This trend has started only recently in my case as we started using in memory OLTP tables and Columstore indexes etc. and were… Read More »

SQL 2016 – Basic Availability Groups

By | January 1, 2016

With database mirroring out of the picture a question on most SMEs mind was how can we get HA on our SQL machines now? Database mirroring was a favorite for most small businesses since it allowed the user to have multiple usable database engines and therefore was able to justify the cost of using SQL… Read More »