VARCHAR = @NVARCHAR and SARGability
In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....
2015-09-07
1,100 reads
In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....
2015-09-07
1,100 reads
You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...
2015-08-20
3,106 reads
Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...
2015-07-31
8,994 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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