Viewing 15 posts - 8,446 through 8,460 (of 49,571 total)
A 5-second google search turned this up:
http://msdn.microsoft.com/en-us/library/ms173571%28v=sql.110%29.aspx
July 14, 2014 at 5:00 am
Cost != duration.
Check the execution plan for the query, see what the cost is, set cost threshold above that. Or just use the maxdop hint on that query.
July 14, 2014 at 4:57 am
No way to answer with that limited information. Please at least post the execution plan.
First though, is that a problem? The costs have to add to 100% across the plan,...
July 14, 2014 at 4:55 am
No, but it will break your log chain and remove any ability to restore to a point in time. Rather set up proper log backups at an interval based on...
July 14, 2014 at 4:19 am
You want the number of count, as grouped by the entire of the select clause?
July 14, 2014 at 4:17 am
What do you want to have happen to the rest of the columns? Max? Min? Something else?
July 14, 2014 at 3:46 am
murnilim9 (7/13/2014)
July 14, 2014 at 1:01 am
July 14, 2014 at 1:00 am
SQLisAwE5OmE (7/13/2014)
If the table is very small, table scan is sometimes faster than seek...so, that's why the fragmentation is getting high again.
Fragmentation has nothing to do with scans (other than...
July 14, 2014 at 12:59 am
SQLisAwE5OmE (7/13/2014)
Instead of waiting for 19 hrs, if downtime was available, couldnt you restart sql?...wouldn't it kill that process?Not exactly sure if its the right approach.
No, it's completely the wrong...
July 14, 2014 at 12:54 am
Grant Fritchey (7/13/2014)
I don't agree that it's spam...
Accounts that don't post anything else, no useful information, often patently incorrect info as to causes (deadlocks don't cause suspect databases) and links...
July 13, 2014 at 9:18 am
Could you two please remove the link from the spam post that you quoted?
July 13, 2014 at 6:29 am
Viewing 15 posts - 8,446 through 8,460 (of 49,571 total)