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,361 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,827 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,584 reads

Blogs

The Book of Redgate: Hours

I have said and written this many times: Redgate Software is the type of...

How to Check TDE Progress and Elapsed Time in SQL Server

How to Check TDE Progress and Elapsed Time in SQL Server ...

PostgreSQL Support in the Data API Builder

Next week I’m at VS Live in San Diego (register and join me) and...

Read the latest Blogs

Forums

Squared Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Squared Values

I Don't Want To Do XX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Don't Want To Do...

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...

Visit the forum

Question of the Day

Squared Values

What happens when I run this code in SQL Server 2022?

SELECT SQUARE('12')

See possible answers