Viewing 15 posts - 18,496 through 18,510 (of 49,552 total)
DDL trigger?
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
May 17, 2012 at 2:59 pm
Ok, these are some of the possibilities, all allow for different RTO and RPO and failover options. One thing I will say is that 8 hours is sufficiently generous that...
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
May 17, 2012 at 12:43 pm
Duplicate post. No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1301943-1549-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
May 17, 2012 at 10:37 am
What's your RPO, what's your RTO? What's your budget? What are your requirements for failover?
There is no 'best' HA/DR solution, it's dependent on your requirements
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
May 17, 2012 at 10:35 am
Can you post the plan 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
May 17, 2012 at 10:13 am
michael vessey (5/17/2012)
you should be able to free up the space in the tempdb after the operation has completed usinguse tempdb
go
dbcc shrinkfile(2,1)
dbcc shrinkfile(1,1)
Please do not suggest that people shrink...
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
May 17, 2012 at 10:10 am
zavhrye (5/17/2012)
This is because of the db being a subscriber any intelligent answer would be appreciated. Thanks.
No, it's not because the database is a subscriber, it's because your database...
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
May 17, 2012 at 10:03 am
Please DO NOT run CheckDB with any repair option at this point.
Please run the following and post the full and complete output.
DBCC ChecKDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
What backups do you...
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
May 17, 2012 at 7:47 am
There are many, many better ways to deal with parameter sniffing problems than forcing specific indexes based on hardcoded row values that have to be manually updated (how long will...
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
May 17, 2012 at 6:33 am
The built in search was useless, so I turned it off. It's on my to-fix list. Should have mentioned the category - indexes - would have made things easier to...
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
May 17, 2012 at 4:54 am
Not without seeing the deadlock graph
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
May 17, 2012 at 4:31 am
Fragmentation can slow down large range scans from disk. That's most of the effect.
For rebuilding...
ALTER INDEX .... REBUILD.
See Books Online for details and see the articles that were posted earlier...
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
May 17, 2012 at 3:54 am
Here's the reason:
george sibbald (5/17/2012)
GAM (3:2) = NOT ALLOCATED SGAM (3:3) = NOT ALLOCATED ...
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
May 17, 2012 at 3:34 am
It's already out of support. The entry that you mention is SQL 2005 Express as a whole, and SQL 2005 is out of support unless you have a premier contract...
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
May 17, 2012 at 12:36 am
Jeff Moden (5/16/2012)
Are you suggesting that if I use something like a tenth of a table that a scan is virtually guaranteed?
If you are using a non-covering index, then absolutely...
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
May 17, 2012 at 12:36 am
Viewing 15 posts - 18,496 through 18,510 (of 49,552 total)