Currently working as a Production SQL Server DBA, Pankaj is an MCSE (Microsoft Certified Solutions Expert) and MCITP (Microsoft Certified IT Professional) certified, technically adept database architect and administrator with demonstrated success in designing and implementing innovative database solutions to improve business functionality.

VARCHAR = @NVARCHAR and SARGability

by pankajmanek

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,280 reads

ISNULL around the predicate and SARGability

by pankajmanek

SQLYSE with Pankaj Manek

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,754 reads

Executing SELECT query using TOP without ORDER BY

by pankajmanek

SQLYSE with Pankaj Manek

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

2015-07-31

10,463 reads

All authors

Question of the Day

While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:

USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers

VARCHAR = @NVARCHAR and SARGability

ISNULL around the predicate and SARGability

Executing SELECT query using TOP without ORDER BY

Blogs

Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!

What is ALM in Fabric?

The Most Successful Startups in 2025 — And What They Have in Common

Forums

A Quick Restore

Guarding Against SQL Injection at the Database Layer (SQL Server)

Ola Hallengren Index Optimize Maintenance can we have data compression = page

Question of the Day

A Quick Restore