Viewing 15 posts - 1 through 15 (of 152 total)
The idea is not bad. It needs to monitor all services, SSIS, SSRS, SSAS and multiple named instances.
October 21, 2015 at 10:47 am
October 21, 2015 at 10:40 am
October 21, 2015 at 10:39 am
However, the bulk-logged recovery model increases the risk of data loss for these bulk-copy operations, because bulk logging operations prevents recapturing changes on a transaction-by-transaction basis. If a log backup...
October 21, 2015 at 10:31 am
This sounds like exactly what I need to do. Can you post some code?
http://dbace.us/repriser/houstonsqlpassvideo.html
SQL Saturday #308
October 20, 2014 at 1:12 pm
You lose some flexibility with that linkserver:-D
September 12, 2014 at 11:44 pm
Index rebuild online is only available in Enterprise Edition
http://msdn.microsoft.com/en-us/library/cc645993.aspx
Online does not mean it does not lock. It is "almost online".
Rule of thumb:
5%-30% fragmentation - use reorg
30%-100% fragmentation -...
July 18, 2014 at 12:06 am
1) You can see how I used Powershell to accomplish this kind of things from one centralized server pulling at SQLSaturday#308.
2) If the VBScript agent has to be delivered to...
May 9, 2014 at 8:53 am
Actually on SQLSaturday#308, I will show you how to generate a restore script from MSDB using T-SQL.
I wrote this and use it for many years on many jobs.
Two...
April 23, 2014 at 8:01 pm
"Both" will be great.
March 10, 2014 at 2:27 pm
Microsoft SharePoint team needs to communicate with SQL Server team, vice versus. Parallelism is a good feature to use, not to surppess.
March 11, 2013 at 2:24 pm
Definitely. I agree with everything in this article. I am glad Erin writes this article as DBA best practice guide.
Alternatively, you could record troubled server by checking counters for CPU,...
December 2, 2012 at 8:08 pm
If you don't want to distribute so much memory on SQL Server usage, just lower the Max memory. You can also issue commands to clear buffer and procedure cache in...
November 14, 2012 at 7:46 am
Viewing 15 posts - 1 through 15 (of 152 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy