Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...

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

SSIS #118–Is it an OLEDB or an SMO Server Connection?

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...

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

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

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

Outlier Detection with SQL Server, part 3.2: GESD

By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...

ROW_NUMBER SQL Server

Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number()...

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