Hugo Kornelis (11/11/2010)

---

2. The rule "Partitions can be on any column" is ambiguous. I was sure I had the rest right, but felt like taking a 50% gamble with this...

There is no grey area on this.

As far as recovery models are concerned the are all supported by DB snapshot.

This IS a question on the MS SQL DBA exam and...

I gift this question fife stars for knot havings type o's and shows correct referance meaterials and knowledge of SQL feartures.

I give the extra star to Carl for the post...

TravisDBA (11/10/2010)

---

So peope will take careful pause the next time they post a question taken right from BOL, as we all have to do, and realize that just because something...

TravisDBA (11/9/2010)

---

More Science Logic: Since you and cengland0 do not like this simple...

cengland0 (11/9/2010)

---

Lets try this logic on DB Backups...

If...

I almost forgot!

I give this question fife stars for knot havings any type o's and shows correct referance meaterials and knowledge of feartures.

I give it an extra star for the...

cengland0 (11/9/2010)

---

That, in my opinion, means that "True" cannot be the correct answer to this question and I already know that "False" was wrong. The only other option...

I am really disappointed with this article and it's information.

Lots of it is directly from the BOL or other articles.

All it told me was:

SHRINKFILE BAD. Be afraid, it does...

Lon-860191 (11/8/2010)

---

Only one small comment, the answer depends on collation for the database where the commands are issued. Some collations are case-sensitive so only the create statement would work and...

Nice question for a monday.

I Also give this question Five stars for have correct code and no typos in the question or the answer.

😎

honza.mf (11/5/2010)

---

What TSQL comand shows the Sever Default dateformat for a MS SQL server 2005 or 2008? 😎

SanDroid (11/5/2010)

---

Hugo Kornelis (11/5/2010)

---

If the default language of your server happens to be, for example, British English, you'll get 1 as your answer. Same for German, Dutch, French, and...

Hugo Kornelis (11/5/2010)

---

If the default language of your server happens to be, for example, British English, you'll get 1 as your answer. Same for German, Dutch, French, and several...

For whatever reason, the crrent version of EXCEL and SQL use differant default formats for storing all data types.

IMO: it...