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

Get Dependent Databases, Tables, Columns…

Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...

Using Excel Macro (.xlsm) Enabled Files in SSIS

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...