Viewing 15 posts - 23,476 through 23,490 (of 49,552 total)
Tom.Thomson (9/17/2011)
Maybe you need both for deadlock avoidance.
It's possible, but I wouldn't start with both on the off chance that a deadlock may occur.
The bottom line is that the missing...
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
September 17, 2011 at 4:56 am
You have two BEGINs (one at the start of the procedure and one after the ELSE) and only one END.
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
September 17, 2011 at 4:20 am
bitbucket-25253 (9/16/2011)
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
September 16, 2011 at 5:51 pm
New question, new thread please.
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
September 16, 2011 at 2:08 pm
ALZDBA (9/16/2011)
Tom.Thomson (9/16/2011)
5) risks of using backup log to append a log backup to an existing file containing log backups instead of always creating a new backup file...
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
September 16, 2011 at 2:08 pm
I'd recommend not, unless you have the need to restore the dev database to point-in-time or you plan to mirror the dev database.
Install a dev instance on your local...
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
September 16, 2011 at 1:50 pm
If it's a dev database, do you need to be able to restore it to any point in time? If not, just switch to simple recovery, run a checkpoint and...
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
September 16, 2011 at 11:21 am
You don't want both. You want the second.
This is one of the major drawbacks of the missing index DMV. The optimiser considers each query in isolation when it optimises and...
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
September 16, 2011 at 9:23 am
I suspect this got lost in all the 'helping Grant abuse SQL' posts...
Another request:
I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction Logs[/url]....
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
September 16, 2011 at 7:09 am
Did you read the blog post that was given in this thread? Did you read the post it links to?
If you did and still have questions, please start a new...
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
September 16, 2011 at 6:59 am
GSquared (9/16/2011)
Yep. Didn't quite nail that one precisely, did I?
Almost everyone mixes up density (measure of how unique an index is), selectivity (measure of the fraction of total rows...
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
September 16, 2011 at 6:57 am
Ninja's_RGR'us (9/16/2011)
I would add that you can consider doing alter index... WITH MAXDOP
Index reorganise can't parallel. It always runs on one thread, no matter what the maxdop settings. It's rebuild...
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
September 16, 2011 at 6:11 am
Not running into this perhaps?
It can happen for any ascending column, not just dates.
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
September 16, 2011 at 3:49 am
Make sure your stats updates are with fullscan.
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
September 16, 2011 at 3:15 am
Update all the statistics on all the tables involved.
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
September 16, 2011 at 2:33 am
Viewing 15 posts - 23,476 through 23,490 (of 49,552 total)