Technical Presentations - What happen's behind the scene
A while ago I wrote a piece on public speaking assignements over here and promised to write what it takes to...
2016-10-27
392 reads
A while ago I wrote a piece on public speaking assignements over here and promised to write what it takes to...
2016-10-27
392 reads
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
975 reads
Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or...
2016-10-17
954 reads
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
2,988 reads
Query Store is perhaps one of the path breaking features to release in SQL Server 2016. This post will give...
2016-10-09
541 reads
Many of us use the stored procedure "sp_recompile" to mark the stored procedure for recompilation, so that next time it...
2016-10-06
1,104 reads
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,055 reads
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
416 reads
Dear All,
It has been a while since I became less active on this blog. Reason for the same being that,...
2016-06-12
392 reads
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,005 reads
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers