-->
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.

DBA Resolutions

In this day and age, it’s absolutely vital to move at the same pace as the database systems.
But how do DBAs reduce time spent on the daily chores to allow them to progress and be more productive?
Here are 5 important tips I’ve mentioned to work smarter and beat… Read more

0 comments, 330 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. My first observations of the preview are here:

A first look at SQL Server on Linux

The post SQL Server on Linux, first observations. appeared first… Read more

0 comments, 428 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, 265 reads

Posted in SQLYSE with Pankaj Manek on 20 September 2016

SQL Server, a true Olympian

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:

  • Discuss a plan to develop skills and strategy, with their coach, which would be put…

Read more

0 comments, 252 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, 921 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,082 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,058 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, 548 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, 792 reads

Posted in SQLYSE with Pankaj Manek on 10 September 2015

VARCHAR = @NVARCHAR and SARGability

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, 669 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,029 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, 2,705 reads

Posted in SQLYSE with Pankaj Manek on 31 July 2015