Viewing 15 posts - 1 through 15 (of 23 total)
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...
May 20, 2010 at 11:37 am
Richard M. (5/14/2010)
Nice one.... also good to use as an interview question 😀
Richard M. (5/14/2010)
Good point. Adding to the list of interview questions!
May 14, 2010 at 7:49 am
Thanks for the response. I stand corrected and will recreate my clustered indexes more frequently 😛
Hugo Kornelis (5/7/2010)
May 7, 2010 at 9:22 am
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...
May 7, 2010 at 9:05 am
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...
April 16, 2010 at 8:12 am
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...
February 26, 2010 at 12:55 pm
May 5, 2009 at 10:03 am
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!
May 4, 2009 at 8:51 am
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...
April 23, 2009 at 8:40 am
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...
April 10, 2009 at 8:39 am
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'.
April 10, 2009 at 6:42 am
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 😀
September 12, 2008 at 7:59 am
Good question! I had to do some investigation of coalesce which looks like a very useful function.
September 9, 2008 at 6:06 am
Hi Chris and Hugo,
Thanks for your responses!
September 4, 2008 at 7:47 am
Doesn't the second solution have to do the same B-tree traversal?
Good question, today, and good discussions!!
September 4, 2008 at 6:05 am