Last year I had spent a decent amount of time writing about tempdb. With SQL 2016 a lot of those point are validated and enabled by default going […]
SQL 2016 – sys.dm_exec_query_stats upgraded version
This is one the most frequently used DMVs for DBA when troubleshooting performance issues and MS has been adding more columns to the DMV with every release. In […]
Sample Script for Partitioning
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 […]
SQL 2016 – Updatable Non Clustered Column store indexes
This might some as a big relief for those who use ODS for Reporting. Previously we have the following limitations with the below types of indexes Clustered Index […]
SQL 2016 – DATEDIFF_BIG
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 […]
SQL 2016 – Compress and Decompress – with a catch! Compress doesn’t always save space
While working at Thomson Reuters I was part of the Search and navigation team and we had a number of reports created around the data being analyzed from […]
Creating a network graph in SQL Server
Over the holidays I have been looking to try out some new concepts in SQL Server and figured I should perform some analysis on all the emails I […]
Renaming all columns in a table quickly
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead […]
The hazards of data types when deleting data
Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below delete from #tmp where data […]
Does Partitioning Improve Performance?
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]