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,143 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,461 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
9,711 reads
Blogs
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Cloud Databases Made Simple: Creating Your First AWS RDS Instance
I recently started full time learning of Amazon Web Services (AWS). I found that...
Forums
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
SQL 2017 throwing BugCheck on differential database restore
Long time listener, first time caller. I have a problem that my usual bag...
cluster node quarantined
evening All hoping someone can shed some light - I have a (originally) 2...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers