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

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

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

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

Day 3 – Reviewing Peers

This is the third 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 3 – Reviewing Peers

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

Friday Followup For December 27, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

MDX #35 – Properties() function with TYPED flag

Reader Query
My publisher recently forwarded me a question from a reader about the “Using the PROPERTIES() function to retrieve data...