SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQLYSE with Pankaj Manek

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.

IF RDBMS = SQL Server, NoSQL = ???

SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features it’s advancing faster than one could imagine. The release of SQL Server 2016 SP1 and, very recently, SQL Server 2017 says it all, really. Whilst the latest changes and new… Read more

0 comments, 364 reads

Posted in SQLYSE with Pankaj Manek on 8 November 2017

DBA Resolutions

It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time of the year to keep up with the tradition and pledge to make some improvements.

In this day and age, it’s absolutely vital to move at the same pace… Read more

0 comments, 525 reads

Posted in SQLYSE with Pankaj Manek on 28 December 2016

SQL Server on Linux, first observations.

Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going to split the world.

Regardless of whether you view this as a major step forwards or backwards, the future release of SQL Server on Linux is highly anticipated. Personally, I… Read more

0 comments, 513 reads

Posted in SQLYSE with Pankaj Manek on 22 November 2016

“Witch” Statistics?

Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three men says, “I’ve got an idea. We can call for help in this canyon and the echo will carry our voices far.” So he leans over the basket and yells… Read more

0 comments, 338 reads

Posted in SQLYSE with Pankaj Manek on 20 September 2016

SQL Server, a true Olympian

Suffering SQL Server Performance Issues?: A story of Olympic sprints and handy SQL Server hints!!!

Usain Bolt, the world’s fastest runner, now boasts his third successive 100m Olympic title.
What makes him so successful? Clearly he’s talented and determined.
But there are some key factors that any athelete would follow: Read more

0 comments, 314 reads

Posted in SQLYSE with Pankaj Manek on 18 August 2016

SQL 2012 Identity Columns Feature

Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this point the first thoughts would be user error or code problem or even someone fiddling in the database. But having dug deeper into this, I came across this “feature”.… Read more

1 comments, 1,245 reads

Posted in SQLYSE with Pankaj Manek on 25 February 2016

Freaky statistics feature

SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a specific performance issue caused by stale statistics – No thrills about spills.

In this article I will talk a bit about the distribution steps in statistics and something that… Read more

0 comments, 1,351 reads

Posted in SQLYSE with Pankaj Manek on 30 October 2015

SSMS 2016 – Compare Execution Plans

Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a new feature in SSMS that allows the user to compare execution plans side-by-side.
Yes! And, hopefully very soon, we would not need to flick between the execution plans but be… Read more

0 comments, 3,375 reads

Posted in SQLYSE with Pankaj Manek on 16 October 2015

No thrills about spills

Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a form of a histogram with at the most 200 steps, regardless of the number of rows in the column or index. A lot about statistics can be found in this… Read more

0 comments, 692 reads

Posted in SQLYSE with Pankaj Manek on 21 September 2015

Work of art – the intra query parallelism deadlock graphs

Look at some of the graphs produced by the intra query parallelism deadlocks, below.










Bart Duncan explains this “phenomenon” (bug, rather) in this article.

The two solutions to this problem are:

  • Adding or tuning an index in order to…

Read more

6 comments, 1,166 reads

Posted in SQLYSE with Pankaj Manek on 10 September 2015


In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query. There is another one that often catches out developers and DBAs.

To start off I have created the following two tables and populated them with the same 3 million… Read more

4 comments, 915 reads

Posted in SQLYSE with Pankaj Manek on 7 September 2015

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, and relates to SQL Server’s ability to seek through an index for a predicate. Non-sargable predicates could lead to poor query performance which is why it’s important to understand this.… Read more

2 comments, 1,763 reads

Posted in SQLYSE with Pankaj Manek on 20 August 2015

Executing SELECT query using TOP without ORDER BY

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY, and not realising that the query could end up returning random results. We will look at this in a bit of details with some examples.

Assuming you are able to… Read more

0 comments, 5,475 reads

Posted in SQLYSE with Pankaj Manek on 31 July 2015