Lost in Translation – Deprecated System Tables – Introduction

When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the...

Lost in Translation – Deprecated System Tables – sysaltfiles

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

New in SQL 2012 (1)

Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:

1. Indirect Checkpoint
Prior to...

SQL Server Performance Tuning Overview

In this blog article I will give an overview of performance tuning based on common situation that occur on small...

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging

I was having a discussion with Idera (@idera_software) dev lead Vicky...

Rebuild indexes based on fragmentation – sp_RebuildIndex

In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...

Several useful T-SQL Function

1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
    ,SUM(OrderQty) OVER(PARTITION BY...

Where to Buy a New Laptop

Let’s say that you are in the market to buy a new laptop or ultra book to replace that old...

SQL Server : Parameter Sniffing

Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....

Why I failed my goals

I have two goals that I have sought to achieve by mid-year of 2012. The deadline I set for myself...