Paul White NZ (3/20/2010)

---

Peter Trast (3/20/2010)

---

"Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. " ?

Really? How can that be? The idea of...

Another lucky guess 🙂

When you pipe the results out to a text file, you get:

StringA,StringB

hello ,hello (one space after first hello)

hello ,hello ...

"Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. " ?

Really? How can that be? The idea of the partition is to locate...

wbeaton-664441 (3/18/2010)

---

3 of the 4 options are correct. But, this statment can't be true:

"Reducing the physical size of a log file requires shrinking the file."

You can truncate a transaction...

I cannot tell a lie... I ran the code before answering this one. 😛

I wanted to pick '1234567890' but I wanted to prove I was "right" first. What a surprise!...

I got lucky and guessed the one with all of the text... 🙂

I am not seeing why the concatenation of the inserts occurs... can someone break this down further??

Great question Julie, even if the explanation was not exactly right. I was unaware of this behaviour, and THAT is the point of asking and discussing it 🙂

vk-kirov (12/17/2009)

---

It would be much better if the options #2 and #3 where not separated from each other. Neither #2 nor #3 in itself does not trigger SQL Server to...

I had my 14 year old solve it 😛

I gave it to her without the SQL code and she did a standard alphabet/number decode... I am going to try it...

CirquedeSQLeil (3/20/2010)

---

Paul White NZ (3/19/2010)

---

CirquedeSQLeil (3/19/2010)

---

That would be...

It is always a GREAT question when something new (for me) is in it!

brdudley (3/19/2010)

---

I'm sensing a loophole if we all just cooperate. Since, by the answer, we have been granted responsibility for the correctness of the answer, we ought to all agree...

🙂

Always pick the first choice when you have no idea 😀

I hate that too...!

Doesn't this work all the way back to SQL 7??