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

The Effective Cell Phone

I’ve written a bit about phones recently as I’ve experienced the switch back to iOS from Android. There are a...

Reblog: December 20 to December 26

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

When DMVs Cost Me My Job

Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA...