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,283 reads
ISNULL around the predicate and SARGability
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,759 reads
Executing SELECT query using TOP without ORDER BY
Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...
2015-07-31
10,466 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers