Tracing call stacks in SQL Server – Introduction

At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at...

PowerPivot Saga 2: DAX OR function (OR there is something better)

I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of...

SQLSaturday#380 NYC Event Update - Precons, Speakers....

Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015.  As you are hanging...

SQL – How to Find Missing Sequence in a table

Problem statement:-
 A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code...

Twas 2 Days Before Xmas or Thank you SQLFamily

Twas 2 days before Xmas & all through the office,

not a creature was stirring not even old Maurice.

With merriment going on...

Blink – Year is gone

As the door begins to knock I start to wonder who it can be. As I begin to open it...

Last Weeks Top “Reading” Links #114

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of...

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is...