I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only […]
You can now create nonclustered indexes on the Clustered Columnstore index
This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that […]
SQL 2016- Live Query Stats
I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 […]
Drawing a graph in SQL Server Management Studio
Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it […]
SQL 2016- Activity monitor – Active Expensive Queries
Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. […]
SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered
So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the […]
Fill Factor and Page split demonstrated
Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and […]
Some new screens you will likely encounter when installing MS SQL 2016
Here a screenshot by screenshot tour on installing SQL 2016, please keep in mind that this is a CTP (preview) so the screens may differ from RTM – […]
Did you know you can launch a trail version of SQL 2016 Azure VM?
But you will be charged for it because it launches the VM under your Azure account and will be billed as per usage. However you can register for […]
The tempdb – why shrinking doesn’t always work
Recently I was working on performance issues for a client and one of the topics we were looking at was tempdb. There was some confusion about when tempdb […]