SQLYSE with Pankaj Manek

In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....

2015-09-07

1,366 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,829 reads

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...

2015-07-31

10,589 reads

After my session at VSLive last week, I had a few questions from the...

Referrals have never been more important in the job market. They’re no longer nice...

dorgone– adj. wondering if you could slip away from an event or group conversation...

I have about 100 Tables that are all suffixed with _Modify. These tables record...

Comments posted to this topic are about the item Make It Routine

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?