Wrapping Up 2013

Last year, I did a wrap up post of the year (also 2011 and 2010) to see where I landed from...

MVP Award for 2014

Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server...

Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)

Question :- 

How many non clustered indexes are possible in a table in SQL Server 2008R2

1)  1
2) 249
3) 999  (Correct answer)
4)...

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

While loop in SQL server

In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....

Final Giveaway And Some Stats

Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

MDX #36 – Many thanks to the reviewers

In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:
The Louvre Museum has 8.5 million...

Slimming down The Voice of the DBA Podcasts

I announced in the Christmas editorial that I was discontinuing the video podcasts. Needless to say I heard a complaint...