Viewing 15 posts - 7,861 through 7,875 (of 49,552 total)
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
I've had the Pink Panther theme tune in my head all...
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
September 11, 2014 at 7:57 am
cafescott (9/11/2014)
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
September 11, 2014 at 7:54 am
Mike John (9/11/2014)
It is quite easy to do this by accident, especially if you miss the BEGIN/END off a stored procedure definition
Nothing to do with the BEGINS and ENDs...
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
September 11, 2014 at 7:27 am
Managing a 4TB database and
Can you please guide me on how to find the root cause of log growth?
Really?
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
September 11, 2014 at 7:25 am
Backup/restore works fine when you need to refresh a dev instance once every few days (which is what that question asks). It'll work for once a day, providing the DB...
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
September 11, 2014 at 7:06 am
Have you fixed what caused the log to grow? If not, this is just going to happen again.
Shrinking the log isn't going to stop it growing again if it needs...
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
September 11, 2014 at 6:53 am
Transactional replication?
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
September 11, 2014 at 6:52 am
I'd open a case with CSS about this:
During undoing of a logged operation in database 'ABC', an error occurred at log record ID (7718257:21496:62). Typically, the specific failure is...
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
September 11, 2014 at 5:33 am
To be blunt. Don't.
That's formatting for display, not data retrieval (unless Address3 has no user, which is what your example implies).
If you want to display like that, look 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
September 11, 2014 at 5:30 am
andrew gothard (9/11/2014)
Personally, I'm well impressed with Pluralsight.
I love Pluralsight. I've started downloading their courses and playing them (audio-only) via the car's sound system when driving to work...
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
September 11, 2014 at 5:12 am
That is 600 lines of code... When I do tuning for clients, that size of procedure would probably take me half a day to work through.
Can you do some investigation,...
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
September 11, 2014 at 5:12 am
No. Should just go read only. Though since running out of space in this case, for some reason, sent the DB into recovery, there's a chance that will happen again.
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
September 11, 2014 at 4:29 am
Clear up some space on D (move other DB's logs or allocate more space) and wait.
What error messages are there in the error log? A full log should not send...
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
September 11, 2014 at 3:58 am
Database state is RECOVERING? (check sys.databases)
Check error logs. Insufficient space should not do that to a DB.
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
September 11, 2014 at 3:43 am
Please note: 5 year old thread.
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
September 11, 2014 at 3:28 am
Viewing 15 posts - 7,861 through 7,875 (of 49,552 total)