Viewing 15 posts - 151 through 165 (of 1,583 total)
+1 to what everyone else has echoed - great question, and unfortunately, one I missed - TGIF!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2014 at 8:11 am
Thanks Perry - I will read through this - thanks for sharing it
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2014 at 7:41 am
Russell; I'm looking to implement something similar to this and I'd be very curious to see how you implement this (seems like a great step-by-step article that you could post...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2014 at 7:20 am
Thanks for the information; I will check it out 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2014 at 7:15 am
2 days after-the-fact, a full check returns no errors
DBCC CHECKDB ('MYDB') WITH ALL_ERRORMSGS, NO_INFOMSGS
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2014 at 6:53 pm
You maybe able to uses the sysprocesses table to determine the hostprocess ID. You can use the hostprocess ID to find the PID on the server it originated from:SELECT
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2014 at 11:08 am
Interesting.
On the other server where I restored the latest full/diff backup, I ran a serious of checks (including the ones you mentioned) and finished it all off with DBCC CHECKDB('SSRS')...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 4, 2014 at 10:43 am
Thanks Gail, as always I appreciate the feedback. Yes, I tried the restart and while it resolved the CLR issues, it still comes back after running a full blown...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 3, 2014 at 12:16 pm
Interestingly enough, running this returned no errors
EXECUTE sp_MSforeachtable 'PRINT ''?''; DBCC CHECKTABLE ([?]) WITH NO_INFOMSGS, ALL_ERRORMSGS'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 3, 2014 at 11:43 am
What exactly isn't working? Are you getting an error? Could be that one of your values in the CASE is NULL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 25, 2014 at 8:29 am
TheSQLGuru (8/18/2014)Don't forget the other part of the equation - Cost Threshold for Parallelism. The default of 5 is universally too low.
What's a good way to determine...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 18, 2014 at 10:18 pm
Thanks for that clarification 🙂 Appreciate it!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2014 at 5:52 pm
hiram.osiris (12/5/2013)
1.-Stop SQL Server service from Configuration Manager
2.-Open CMD console as administrator and go to the following path: C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012(Here...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 8, 2014 at 7:43 am
Seems about right but would strongly encourage you to verify that the anonymous/immediate_sync options have been set properly, if they are not set to 0, when you trigger the snapshot...it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2014 at 11:13 am
You can query the BackupSet and BackupMediaFamily tables in the msdb database:SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
bu.database_name,
bu.backup_start_date, ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2014 at 9:24 am
Viewing 15 posts - 151 through 165 (of 1,583 total)