"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives." :w00t:

Are you serious? What if I only have one disk (physical or logical (like...

Ray Laubert (12/8/2009)

---

Thanks, that is what I would have expected. CharIndex would create a situation that invalidates the Index View and basically forces SQL to the underlying tables.

But...

vk-kirov (12/8/2009)

---

This is incorrect. Check BOL (Deterministic and Nondeterministic Functions): http://msdn.microsoft.com/en-us/library/ms178091.aspx

All of the aggregate...

Please give bitbucket and Lynn a break! It is hard to write questions to QoT and I have never and never will write a QoT due to all the preasure...

Lynn Pettis (11/17/2009)

---

I actually answered true, and here is why, if you run this:

select getdate(), getutcdate()

you may get a result like this:

2009-11-17 06:16:57.527 2009-11-17 13:16:57.527

They appear different, but are actually...

I agree, everyone does not live in GMT zone or install our OS with GMT...

ebenraja (10/29/2009)

---

Hello friends,

I do have a 'SQL user' who runs a lot of queries that causes performance issues to the database machine. I want to write a query that would...

jcrawf02 (10/29/2009)

---

I can just see me being the only one on in the middle of the night, running 'SELECT TOP 10 employee FROM staff' and wondering why it keeps failing...

Fatal Exception Error (10/16/2009)

---

I based my answer on reality. In reality data is not immutable. What is true today probably won't be true six months down the...

Hugo Kornelis (10/16/2009)

---

That's reallly a shame, as the only good reasons to use varchar instead of char are a difference of more than 2 between average and maximum length; or...

diamondgm (10/16/2009)

---

Firstly, we assume that the average is the result of an even spread (that the average length is in fact 8.5 - we only need an average of 8...

Thank you!! This solved my issue and you saved us a lot of money.

Harold Joubert (9/27/2009)

---

I have a 64-bit Windows 2003 server with SQL 2005 Standard (64 bit). trying to...

As you all pointed out Bool does not exist in SQL Server, and I replaced it with a char(1). In my environment (SQL server 2008 on a server with 4...

The answer option with a clustered index included dropping of same because it had to be assumed that the schema should remain unchanged. In an idea world, a table with...

I got 3.4 in SQL server 2008, but I expected to get 3.399999