Viewing 15 posts - 8,146 through 8,160 (of 49,552 total)
Yes they are, but they're very well tested and very comprehensive
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
August 12, 2014 at 7:23 am
Do you have every single transaction log backup from the Monday full backup up to now? Every single one without a gap?
Has the database been set to simple recovery at...
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
August 12, 2014 at 7:22 am
To be honest, I'd say ditch your custom script and just use the one at http://ola.hallengren.com/
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
August 12, 2014 at 7:02 am
I thought you meant it was still running. No, there isn't any history of that kind of thing. After the fact it's near-impossible to figure out why something ran long...
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
August 12, 2014 at 6:55 am
All the comments I made in the previous thread still stand.
This should be an INSTEAD OF trigger, not an AFTER
The trigger as written will not handle any insert or update...
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
August 12, 2014 at 6:54 am
Any blocking? What's the process waiting 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
August 12, 2014 at 6:29 am
A little old, but still mostly valid
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
August 12, 2014 at 5:12 am
- Win (8/12/2014)
Log file size did not changed, it is the same size...
No, it won't, because checkpoint doesn't shrink log files.
It may however have freed some space internally
Can you 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
August 12, 2014 at 4:44 am
- Win (8/12/2014)
Making offline and online DB helps ?
NO!
Never take a DB offline if it's showing any kind of errors like this.
Making DB to Full, backup, then revert 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
August 12, 2014 at 3:08 am
Beatrix Kiddo (8/12/2014)
You know everybody can read this thread, right? It was an honest mistake and I apologised immediately. Is this really necessary?
Is what really necessary?
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
August 12, 2014 at 2:58 am
Beatrix Kiddo (8/12/2014)
Try increasing the autogrowth then trying the backup again.
When the drive the files are on is full? How would that help?
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
August 12, 2014 at 2:50 am
The log could have grown for any number of reasons. Large transaction, replication, CDC, lack of a checkpoint, active backup, couple of others.
Can you shrink the log a little?
If 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
August 12, 2014 at 2:48 am
So three days after implementing replication, I have a pile or replication-related errors on my desk (cannot truncate table because it's replicated, lob size exceeds max replicated text size)
How 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
August 12, 2014 at 2:45 am
The temp table will be dropped as soon as the procedure that created it ends, whether it ends successfully or not does not matter. There's nothing you need to do,...
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
August 12, 2014 at 2:41 am
No.
The NoCheck option means that the old data is not checked for compliance with the constraint and therefore cannot be trusted. If you want the constraint trusted, you need 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
August 12, 2014 at 1:13 am
Viewing 15 posts - 8,146 through 8,160 (of 49,552 total)