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

Determine space used for each table in a SQL Server database

I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...

Database Interview questions

I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.

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

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

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

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

Win A Free Registration to SQLskills Immersion Event 1

You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training...