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,140 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,140 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,450 reads
Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...
2015-07-31
9,671 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Hi everyone My query works for most cases. There is one edge case where...
Hello, I was given this SQL question and was hoping someone could please help...
In recent days past, there was a Performance gain by placing data files, log...
How does the Resource database in SQL Server 2022 get backed up?
See possible answers