Viewing 15 posts - 36,136 through 36,150 (of 49,562 total)
October 26, 2009 at 10:26 am
Per Books Online
ALL
Specifies all indexes associated with the table or view regardless of the index type. Specifying ALL causes the statement to fail if one or more indexes are in...
October 26, 2009 at 10:26 am
allen davidson (10/26/2009)
October 26, 2009 at 9:32 am
SanjayAttray (10/26/2009)
Then why do we see index scan and table scan separately in...
October 26, 2009 at 9:13 am
The log can only be truncated up to the beginning of the oldest active transaction. If you're trying to insert an entire (large) table, then that will run as a...
October 26, 2009 at 8:13 am
WilliamD- (10/26/2009)
are you flying Air France by any chance? I have pretty similar times for my flight from Paris to Seattle.
Air France/KLM. Stopping in Paris on the way there,...
October 26, 2009 at 8:08 am
huston.dunlap (10/26/2009)
One thing I have found hugely successful so far is breaking down large queries into Temp Table work and then manipulating those tables (especially to get away from subqueries).
In...
October 26, 2009 at 8:03 am
It's something to worry about. IO errors are always something to worry about. Will see if I can pass this on to someone who will know the details of that...
October 26, 2009 at 7:50 am
Ha ... Ha ... Ha ....
Leaving Friday evening. Breakfast Saturday morning in Paris, arrive in Seattle around 1pm Saturday afternoon.
21 or so hours of flying, 4 hours layover. Had better,...
October 26, 2009 at 7:47 am
A plan will never warn of out of date stats, only of missing stats. Does manually updating the statistics fix the problem?
Very likely parameter sniffing. Check out this short series....
October 26, 2009 at 6:50 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic808633-338-1.aspx
October 26, 2009 at 6:48 am
Krasavita (10/26/2009)
The way I understand the loop is running until hits < 4 million of records
Yeah, pretty much. Since rowcount is 4 million, the only time the update will do...
October 26, 2009 at 6:38 am
Another CPU? I'm not sure I understand what you're asking. More details please?
October 26, 2009 at 5:23 am
Brandie Tarvin (10/26/2009)
RE: DBCC UpdateUsage - this requires table names. Better to use "sp_updatestats" and it'll get all tables at once.
DBCC UpdateUsage and sp_updatestats do completely different things. Are you...
October 26, 2009 at 5:22 am
arun.sas (10/26/2009)
Thanks, but the results vary by set nocount on/off
Nope, it's not the setting of NoCount that's the cause.
Is anything I miss to obtain the result?
Yes. Common mistake. It's not...
October 26, 2009 at 3:59 am
Viewing 15 posts - 36,136 through 36,150 (of 49,562 total)