Damn, should have known. If IE can do something then that makes it valid. Oh, yeah, and should have known that I could add XML code in order for that...

Good point. Adding to the list of interview questions!

Hugo,

Thanks for the response. I stand corrected and will recreate my clustered indexes more frequently 😛

Thanks,

Joe

Hugo Kornelis (5/7/2010)

---

dunnjoe (5/7/2010)

---

I believe this explanation is incorrect for the way the question was...

I believe this explanation is incorrect for the way the question was asked. Your question asked if the rows were physically or logically ordered, not if the pages were physically...

This was a good question, and makes me wonder if it is a good idea to have auto stats turned on.

When I ran it on one of my servers I...

Thanks, this worked great for me!

Shamshad Ali (3/2/2006)

---

I have fixed it.

Thanks for closing this POST.

======================================

Here is the solution:

You should make sure that Visual Studio is still installed.

If you didn't...

ghollis (5/5/2009)

---

Hit CTRL + T that then run it again. That will put you in text mode so the result and messages are on one screen. CTRL +...

Good question. I had to debug an issue just like this last week with one of the developers. We decided we liked the old style syntax better!

The posts for this message are very informative, but I don't see that they invalidate the answer. There were no deletes, so no fragmentation would be created. The nonclustered index...

I suspect that the reason the error message was because the master database was in use, not because it is invalid to set read only on master. Since all the...

This is what I got when I ran it in 2005...

Msg 5058, Level 16, State 5, Line 1

Option 'READ_ONLY' cannot be set in database 'master'.

I'd like 20,000 points so I'd be on the top of the list when everyone logs in each day, alright, at least on my birthday 😀

Good question! I had to do some investigation of coalesce which looks like a very useful function.

Hi Chris and Hugo,

Thanks for your responses!

Joe

Chris,

Doesn't the second solution have to do the same B-tree traversal?

Good question, today, and good discussions!!

Joe