Good question series. Got owned on the first 2 questions, so decided to read and test a bit on the subject. Now the last 2 questions i have been able...

Okay this might come on a bit strong but anyway.

Are you kidding me?

Having a table without anything to uniquely identify a row... okay thats bad.

Okay you say lets create a...

Nice question. Though the explanation isnt entirely accurate. Its not rounded, its truncated.

If the question had been, lets say

declare @r decimal(5,2)

set @r= round(5/3.2,1,3)

select...

Nakul Vachhrajani (9/16/2010)

---

Hugo Kornelis (9/16/2010)

---

This question is actually almost similar to the one two days ago. The only real difference is the use of the extra keywork WORK (that is...

mlabedz (9/10/2010)

---

First off, I think the article was well intended. However, being a seasoned vet with SQL and SQL performance, I think that your article was more of an...

"ALTER INDEX PK_MyId ON MyTable DISABLE" at this line my brain stopped.

Nice question. Though i think it would have been better if i had stopped at the row above....

As for the resource database in SQL2008. Wouldnt you be able to reinstall SQL on a different drive and then copy the old to the new location.

http://msdn.microsoft.com/en-us/library/ms190940.aspx

Im guessing "<drive>:\Program...

Syntax check only. And the syntax is okay. But that doesnt mean...

Hugo Kornelis (9/6/2010)

---

tommyh (9/6/2010)

---

Because Microsoft...

da-zero (9/6/2010)

---

tommyh (9/6/2010)

---

Because Microsoft havent...

Because Microsoft havent implemented it.

We...

Using...

:Whistling:

Hugo Kornelis (8/24/2010)

---

ziangij (8/23/2010)

---

Frankly, this surprises me a lot more than...

ziangij (8/23/2010)

---

plz. refer http://technet.microsoft.com/en-us/library/ms175003.aspx

for

select ROUND(748.58, -3)

result displayed is 1000.00

but when i execute the same i get an error:

An error occurred while executing batch. Error message is: Arithmetic Overflow.

any...