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,114 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,249 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,303 reads

I am not a great software developer. I’m OK, and I do know how...

Today’s coping tip is to appreciate your hands and all the things they do...

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...

I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...

Hi All, We see some tables in Prod are having 20-30 indexes and we...