Question of the Week - 2/1/2014 - Question 1

Question :-
Suppose we have to design a database in which employees can work on multiple projects.There are many designation defined...

Reflections on 2013

2013 was a year of incredible growth, change, and challenge for me. This last year has been an amazing roller coaster...

Setting up the Min and Max Memory options on the fly – Word of caution !

Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...

Some Thoughts on the Target Breach

Possibly as many as forty million credit cards used at Target were compromised. A staggering breach and a cautionary tale...

SQL Server 2014: Master Data Services Backing up your data models.. A necessary evil !!

 
Introduction
A few days back, in my article entitled ‘Master Data Services 2014: Creating nightly load processes’, I discussed the setting...

Things I Learned in 2013

It’s 2014 now. I hope you had fun in new year’s eve. 
2013 was an amazing and intense year. To recap...

Virtualization for SQL Server DBAs – SQL Saturday Pre-Con Training

My next all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL Server DBAs” will be held on January 17th...

Welcome To 2014

A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what...

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

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