This datatype has an interesting twist to it. If you have a database with case-sensitive collation, such as, for example SQL_Latin1_General_CP1_CS_AS then the following line of code will produce error:

declare...

The best possible prelude will be Gail's own excellent article titled Introduction to Indexes. It has 3 parts, first was published here last September and others...

JosephDMarsh (2/5/2010)

---

I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before actually studying...

It is interesting how the engine behaves when the second part of DSql changes to something different. For example, if instead of deleting the records from the table the second...

This is an excellent question, I thoroughly enjoyed it. I guess the reason why initially it is tempting to select 0 as a correct answer is incorrect assumption about when...

I think I can. I chose the 0, 1 option it...

This is an excellent question, thank you bitbucket. I did not know about the side effect of the ansi_defaults settings in 2008, so I answered incorrectly, but learned something. As...

Adi Cohn-120898 (1/6/2010)

---

I’m sorry, but this question is not a good one. With the information that we got from the question, there is no way that can know...

bitbucket-25253 (1/5/2010)

---

Why kaspencer, why -- so a user can cut and paste ... that is a heck of a way for a person to test their knowledge ...

Now if...

Not that there is anything wrong, but there is no explanation in the answer about the "Dropping and rebuilding a clustered index on a partition scheme may move data to...

Scott Coleman (12/7/2009)

---

The LEN() function ignores trailing spaces, comparing the strings doesn't actually ignore trailing spaces but it pads the shorter string with spaces. The answer's the same either...

sknox (12/7/2009)

---

But in this example, SQL server isn't comparing strings at all. It's comparing integer values (the length of each string.)

The correct explanation is that SQL server ignores trailing spaces...

Siddharth,

This is a very useful article, thank you. I do have some comments regarding the Standards for T-SQL Coding document. There is no doubt that existence of such document is...

Steve,

This is absolutely correct. It is clearly my bad, I did not...

Lynn Pettis (11/19/2009)

---

Forget the question for a bit. If the columns or variables are properly named and/or documented to allow the developer to know what data is stored in...