Viewing 15 posts - 27,931 through 27,945 (of 49,552 total)
Wait, but you could wait forever. Short answer, no. If you have mirroring and you stop the service on the principal, it will failover.
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
February 4, 2011 at 12:25 pm
Craig Farrell (2/4/2011)
mike 57299 (2/4/2011)
1) Checkpoint
2) Backup Log File
3) DBCC Shrinkfile ( log 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
February 4, 2011 at 12:24 pm
Leave point 3 out. It is a bad idea to regularly shrink the log. It should only be shrunk after some unusual (once-off) operation has caused it to grow far...
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
February 4, 2011 at 12:23 pm
Please read through this - 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
February 4, 2011 at 11:09 am
Still not the right files in the right order.
I suspect at this point you may be best off restoring the last backup you have.
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
February 4, 2011 at 11:07 am
Works with pork chops, probably better with thinly sliced pork fillet
Marinade the pork in a mixture of brown sugar, olive oil, crushed garlic and dark rum. Marinade at least 8...
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
February 4, 2011 at 10:59 am
dhar.abhay (2/4/2011)
Thanks Ashish ,But this is 2005. any way to do the same in 2005 sql server ?
Ashish's solution wouldn't work in 2008 either, as the default trace (and hence...
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
February 4, 2011 at 9:58 am
Who's pork chop recipe? iirc there were several of them.
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
February 4, 2011 at 7:10 am
p.s. Consider getting a consultant in if it's urgent and you aren't sure where to start.
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
February 4, 2011 at 6:26 am
Locking hints override the isolation level. Take the hints out first. Which of the snapshot isolations are you using? Snapshot or read committed snapshot?
Don't assume that it's locking, check what...
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
February 4, 2011 at 6:25 am
Something I tried yesterday that turned out wonderful. No quantities given, that's not how I cook.
Strawberries (preferably not the perfectly ripe, wonderfully sweet spring ones. Rather use this if 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
February 4, 2011 at 5:58 am
Do you have the old master database? If not, the point's pretty moot as to whether you need it or 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
February 4, 2011 at 2:31 am
Gianluca Sartori (2/4/2011)
Usually, when the optimizer decides to pick a parallel plan it's because it could not find something "smarter" to do.
Or because the data volumes are large enough 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
February 4, 2011 at 2:30 am
The query is running in parallel (over multiple threads), that's why there are multiple entries for it.
You'll notice that all but two are suspended, means that some of the parallel...
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
February 4, 2011 at 2:00 am
The default trace (which is where the schema change report pulls its data from) does not contain any information about row deletions. It has schema changes (create, alter, drop), 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
February 4, 2011 at 1:56 am
Viewing 15 posts - 27,931 through 27,945 (of 49,552 total)