Changing physical locations of all DBs

I got a request this week from an application engineer. The request was to move ALL physical database files from...

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

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

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