What keeps clearing my query stats?
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
1,962 reads
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
1,962 reads
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,356 reads
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,050 reads
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,693 reads
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
936 reads
I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.
For...
2016-10-29
753 reads
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,044 reads
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...
2016-10-26 (first published: 2016-10-17)
2,803 reads
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,131 reads
Today is the last day to register to vote in Texas. I’m not sure about other states in the US...
2016-10-11
423 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers