The party runs itself for the most part, and I press a few RG people into service for volunteers. Come enjoy, gamble, say hi to a few people. It will...

We are getting a lot of new people writing questions, so there isn't this history of "trying to make it hard" with them. Kind of good.

Nice question, I saw it...

Is your log file not allowed to grow? Or is the disk full?

You likely have a large open transaction, as Adam mentioned. Are you running log backups? These clear committed...

Have you checked these tables to see what's on the secondary server as far as restores/not restores?

http://msdn.microsoft.com/en-US/library/ms190224%28v=SQL.90%29.aspx

I believe it goes on LSN, checks the first one in the backup file...

Ha, I don't gamble! Went to a casino in New Orleans at Tech Ed, watched a friend lose a few hundred. Looks easy, can't bring myself to drop $5 there....

You should read about this in Books Online.

Transaction logs are used to ensure that all data is correctly and properly written to disk.

Trace files are created when a trace is...

I like BTs advice. Look for general IT work. Help desk, sys admin, etc. That type of stuff often does lead to DBA work, especially in companies that don't know,...

The t-log is write intensive. You'd have to test the perfromance of the drive, but I suspect that the benefits of separate drives would be lost with the latency of...

I have never had the same passwords in production as test/dev

It tends to be hard to fire anyone when you have an HR department in the company. They want to be sure the company won't get sued. I'm not sure...

Dave Ballantyne (6/16/2010)

---

I dont normally post other forums "posted questions getting worse" but this one i had to share.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ce4bc469-c62a-4751-8524-062cd67df730

Q1 ) How to make dateadd subtract.

Q2) How to subtract not 15...

I wish that happened for...

I's not difficult to manage the files, but in a crisis, it can be an issue. If you don't have the data on hand on the same backup tape, it...

There have been numerous quotes, quite a few in financial publications like this: http://www.ft.com/cms/s/2/d2f3f04e-6ccf-11df-91c8-00144feab49a.html

Google would have to put out a press release to deny this or they are manipulating stock...

I'd tend to agree with Jack. The abstracts that catch my eye more are ones that have specific details about what is being covered. Rather than general "troubleshooting with SQL...