I rated this article "poor". A lot of the information is correct, and relevant - but there is a very important error, right at the start of the article.

The author...

tommyh (8/24/2010)

---

Hugo Kornelis (8/24/2010)

---

ziangij (8/23/2010)

---

Frankly, this surprises me a lot more...

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

taylor_benjamin (8/23/2010)

---

I disagree that option 1 is the right choice. It stated that Option 1 was faster and must therefore be the correct choice. However, option 1 lost a constraint...

pankaj upadhyay (8/23/2010)

---

thanks actually i get confused after reading the ans Either char(1) or varchar(1) may be used. for this question that when we take varchar(1) than will it save...

pankaj upadhyay (8/23/2010)

---

not this is about that question "I have a variable that will hold one character of data and will never be a null or an empty space....

(removed - I thought this was in a different discussion)

Toreador (8/20/2010)

---

Which...

I got it right, but it was a coinflip. You can actually run DBCC CHECKALLOC and DBCC CHECKCATALOG on tempdb. You will not get an error, but on the other...

Michael Riemer (8/19/2010)

---

If the Group is inside the sequence Container (definitely possible) I don't see why the tasks can't connect to it! If my package only has one sequence container...

andrewd.smith (8/18/2010)

---

I can imagine some reasonable uses for an IDENTITY column where duplicates are allowed / expected.

Say we have some sort of versioning system where the version number comprises a...

jts_2003 (8/17/2010)

---

So would it be fair to say that the third argument of ROUND, function, actually ensures you round down instead of up, if you set it to a non...

Good question. And I have no idea.

I did check...

Huh? I executed this...

OCTom (8/16/2010)

---

Perhaps Microsoft should change it so that a PK or unique constraint must accompany an identity column? Like you say, it doesn't make sense to have it this way...