Viewing 15 posts - 31,651 through 31,665 (of 49,552 total)
Int Identity? Int something else? Always deleting the same number of records per companyID that you're inserting?
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 25, 2010 at 9:39 am
Without seeing things like what the indexes (clustered and nonclustered) are on, what ranges of data is inserted and deleted, it's near impossible to say.
Do note that deletes do not...
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 25, 2010 at 2:40 am
And this http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/ (plus both the articles it links to) and http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/ (and all the articles it links to) and finally http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.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 25, 2010 at 2:34 am
Your best bet for optimising that is to get rid of the while loop. I just took a brief look, but I couldn't see anything that needed row-by-row checking.
You should...
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 24, 2010 at 8:50 am
You cannot specify a column name in a variable. What that statement is going to do is to compare the value of the variable with the value of the agentid...
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 24, 2010 at 8:42 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic958374-146-1.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 24, 2010 at 8:40 am
Why do you want to shrink the logs of all databases? Are you trying to hinder performance on all databases?
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 24, 2010 at 8:38 am
So there is nothing preventing log reuse and the log should not be currently growing.
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 24, 2010 at 5:52 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 24, 2010 at 1:21 am
Lynn Pettis (7/23/2010)
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 24, 2010 at 1:17 am
kladibeeto (7/23/2010)
If you perform rebuild then you don't need to update statistics because rebuild also update statistics.
Rebuild only updates index statistics, not column statistics. The update stats is still...
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 23, 2010 at 4:18 pm
Statistics are invalidated when the threshold of changed rows is exceeded. I can't recall the thresholds for below 500 rows (they're hardcoded values), but there's a threshold at 500 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
July 23, 2010 at 4:15 pm
hxkresl (7/23/2010)
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 23, 2010 at 2:29 pm
hxkresl (7/23/2010)
So, 'read-only' is the state that a snapshot database is in only until it's been RESTORED! Who doesn't know that????? 🙂 Thanks.
No, no, no, no, no.
A...
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 23, 2010 at 2:03 pm
Depends what you mean by 'corruption'
If you mean deleted rows, dropped tables, then yes, a DB snapshot will fix that.
If you take a DB snapshot at 8am, and something...
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 23, 2010 at 2:00 pm
Viewing 15 posts - 31,651 through 31,665 (of 49,552 total)