Memory Timeouts

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...

A New Year is Right Around the Corner

If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...

Final December Giveaway!

Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...

Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 5 – Peer Identity

This is the fifth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

Deleting Duplicate rows using CTE

Many times we caught in a situation where we have a table where there is no primary or unique column...

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 4 – Broken Broker

This is the fourth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

Answer -Question of the Week - 25/12/2013- Question 1

Question:- Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it...

Question of the Week - 28/12/2013 - Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows...