Well, there had been many instances when the QOD query was wrong and it was corrected later. I thought so and ignored " ; " in syntax in sub...

If the answers were only Yes and No then I would had think twice on what to answer or would had done some Google work, but with This is configurable...

Tabify Selected Lines – Replaces the leading whitespace on...

tommyh (7/6/2010)

---

UMG Developer (7/6/2010)

---

Nice question, thanks!

I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome....

different answer for different sql versions.

SQL 2005 and 2008 gives 21 while 2000 with nvarchar(8000) throws error

Msg 2717, Level 16, State 2, Line 1

The size (8000) given to the parameter...

http://www.sqlservercentral.com/questions/Indexes/68595/

Number of Clustered indexes in SQL 2005 is one and 249 non clustered indexes, altogether 250 indexes for a table in SQL Server 2005. In SQL Server 2008,...

Thanks Hogo for explanation.

I was completely lost in question and does not even know what to answer. A brain teaser with small query is always good but with this...

Huh..........Still a lot to learn. Trying to understand the programming puzzle.

Good question, though.

Even though I got it right and know its possible but when executed in SSMS 2005 it returned error.

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value...

tommyh (6/16/2010)

---

Well with 17% wrong answers i would say that some people think that there...

It will get created. Is there a reason, it would not get created ?

nils,

Just trying to figure out...

Is it this, that you are looking for?

http://www.mssqltips.com/tip.asp?tip=1499

http://www.mssqltips.com/tip.asp?tip=1619

A database FULL backup. In my last project all DBA's used to call a backup as dump. (may be because they are both sql and oracle dba's). ...

many reasons, mainly :

1. Missing device causes database to be marked suspect.

2. Disk out of space and no space to expand log file.

3. If one or more database files are...