Viewing 15 posts - 4,501 through 4,515 (of 49,552 total)
I don't keep thousands of links on hand just in case someone happens to need one. I use google for that.
The exact site is the first link returned by 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
October 15, 2015 at 8:52 am
https://www.google.com/?q=Glenn+Berry+diagnostic+scripts
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
October 15, 2015 at 8:37 am
There are a lot of waits that should be high (most '%sleep%' waits for example) because they're from background processes that do some work and then go to sleep until...
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
October 15, 2015 at 8:28 am
Make sure you're using the 2012 config manager, not the one from any previous instances installed on that server.
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
October 15, 2015 at 8:15 am
nawillia (10/15/2015)
thanks. just confirming. someone seems to think this is feasible.
Ask them to show you how to do it. :Whistling:
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
October 15, 2015 at 7:50 am
Brandie Tarvin (10/15/2015)
GilaMonster (10/15/2015)
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
October 15, 2015 at 6:04 am
My desktop's decided to pack up and die. This morning I unlocked the computer to find that all drives except the boot drive were missing from Windows Explorer. Each time...
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
October 15, 2015 at 5:26 am
Click start and type Configuration Manager, let the search find it for you. The app you're looking for will be called "SQL Server 2012 Configuration Manager", you can start the...
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
October 15, 2015 at 4:03 am
Additional opinions needed here please: http://www.sqlservercentral.com/Forums/Topic1727487-3411-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
October 15, 2015 at 3:39 am
BL0B_EATER (10/15/2015)
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
October 15, 2015 at 3:38 am
SLA isn't just about architecture. It's about people and process as well.
If I have a requirement for no more than 30 min of downtime and no more than 2 hours...
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
October 15, 2015 at 3:36 am
No. You'd have to restore the filegroup, then all log backups since the filegroup backup, including the one that contains the truncate table statements. You can't restore part of 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
October 15, 2015 at 3:05 am
A check constraint is used to enforce limits on column values. For example CHECK Rate > 0 would ensure that only values greater than zero can be put into the...
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
October 14, 2015 at 1:59 pm
With a default recovery interval, SQL tries to keep the estimated recovery time under 1 minute, you get checkpoints about every minute for active databases, can be less often for...
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
October 14, 2015 at 9:36 am
JakDBA (10/14/2015)
"An error occurred during recovery, preventing the database 'ObfuscatedName' (8:0) from restarting. Diagnose the recovery errors and fix...
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
October 14, 2015 at 9:21 am
Viewing 15 posts - 4,501 through 4,515 (of 49,552 total)