Viewing 15 posts - 8,446 through 8,460 (of 49,552 total)
A 5-second google search turned this up:
http://msdn.microsoft.com/en-us/library/ms173571%28v=sql.110%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 4:57 am
Does that include xxxCustDelivDump.InvDate?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 4:19 am
You want the number of count, as grouped by the entire of the select clause?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 4:17 am
What do you want to have happen to the rest of the columns? Max? Min? Something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 3:46 am
murnilim9 (7/13/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 1:01 am
Don't shrink.
http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2014 at 12:54 am
Err, don't understand the question
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2014 at 9:27 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2014 at 9:18 am
Could you two please remove the link from the spam post that you quoted?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2014 at 6:29 am
nm.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2014 at 11:15 am
Viewing 15 posts - 8,446 through 8,460 (of 49,552 total)