Viewing 15 posts - 12,301 through 12,315 (of 22,214 total)
opc.three (6/14/2011)
The StatementSetOptions in the XML are apparently wrong per this bug report:
The bug report is for one of the 2008 CTPs but the bug is there in my...
June 14, 2011 at 10:24 am
Yep, that would do it.
You may also have to drop individual database users as well, especially if that login created objects out on the databases with itself as owner.
June 14, 2011 at 9:41 am
So, do I understand correctly, the shutdown was taking a long time or was hung? Did you just power off? Sounds like it was trying to deal with an open...
June 14, 2011 at 9:40 am
Was the reboot in response to a problem or was it a clean shut down because of a service pack or something? If you shut down because of a hung...
June 14, 2011 at 8:29 am
Without seeing both execution plans, we're just guessing.
Let's speculate for a moment. Maybe, you're getting timeouts on the optimizer. Adding a nonclustered index changed the order in which plans were...
June 14, 2011 at 7:31 am
Gail & Gus have largely addressed everything. Only thing I'll add is if you want details on configuring tempdb go by Paul Randal's blog sqlskills.com. He has several excellent articles...
June 14, 2011 at 7:04 am
The load on tempdb absolutely increases. You have to be sure that you have that configured correctly and that you can support more space in tempdb. Other than that, it...
June 14, 2011 at 6:09 am
Sorry, I didn't see this question (still can't get the RSS feed to work for this topic). I've been doing lots of experimentation with SQL Azure, as Steve pointed out....
June 14, 2011 at 5:59 am
For really small sets of data, no, you won't see much of an improvement. But as you start stuffing more keys on a page for an index, you will see...
June 14, 2011 at 5:11 am
Alphabetically 'S' is greater than 'C'
If you think you're comparing the lengths of the strings, you're not. You need to use LEN to see the number of characters or DATALENGTH...
June 14, 2011 at 5:01 am
There are places where you will run into situations where the 2000 query can run faster than the 2005 query. In all the cases I've seen so far, there were...
June 14, 2011 at 4:57 am
Compression gives a huge performance bonus at a slight cost to CPU. Yes, you're moving less to & from the disk, but even more importantly, you're storing more rows on...
June 14, 2011 at 4:52 am
The real question is, why are you so concerned with ghost record cleanup? In certain situations where you have extremely high volume deletes you can run into issues, but in...
June 14, 2011 at 4:46 am
Instead of using group by, try using TOP 1 and an ORDER BY statement. That usually works better.
June 14, 2011 at 4:42 am
I'd start with this excellent article from Buck Woody. He lays out most of what you need to get going.
June 14, 2011 at 4:41 am
Viewing 15 posts - 12,301 through 12,315 (of 22,214 total)