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,354 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,812 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,567 reads

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

We aren’t the only company that does this, but Redgate Software does try to...

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Comments posted to this topic are about the item The New World Of AI...

Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...

Security has long been a problem for me. Every time I think I understand...

What does this return on SQL Server 2025?

select bit_count(null)