Day 8 – Ring in The New

This is the eighth 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 8 – Ring in The New

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

Happy new year!

Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...

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