Hugo Kornelis (10/12/2010)

---

No.

The author of the question uses a long explanation to expand on how usefull the possibility to use...

Thanks for the question! Learned something today. I knew about the default length for char/varchar, but not the convert issue. An important sample to show why you shouldn't omit default...

SanDroid (8/10/2011)

---

hakan.winther (8/10/2011)

---

SanDroid (8/10/2011)

---

As would I if the error in the script did not cause the wrong result.

It seems incorrect to give a...

I agree with you! There are so many databases with performance issues and...

SanDroid (8/10/2011)

---

As would I if the error in the script did not cause the wrong result.

It seems incorrect to give a point to...

I expected it to work and it did ( as it should in most countries except in brittain ) 🙁

j_baldwinson (8/10/2011)

---

I was expecting the fragmentation to grow on the basis that pages at the end of a database file get moved to empty pages earlier during a shrink.

When i...

I am surprised that 60% thought it wouldn't increase! Shrinking a databases is like the opposite of defragmentation! I have seen some terrible examples at some clients using "auto shrink"...

Good question, i thought it would happen upon insert, but I didn't realize that it was not persisted.

You can read another discussion about row count at :

http://ask.sqlservercentral.com/questions/1980/how-do-i-get-a-list-of-sql-server-tables-and-their-row-counts?page=1#1983

Good question! I also want to recommend everyone to create one or more filegroup for user objects (like tables and indexes) and never place any user object in primary filegroup....

Tanks for the question, I learned something today.

Thanks for the trick question, I am glad someone dares to post questions to QotD.

The correct answer should be "it depends". As already stated, there are no guarantees even it seem to work in some cases, but with larger tables, parallell plans, many users...

Excellent question, I guessed the right answer, but I definitely learned something.