Try checking out the US Postal Service website.

If there is not a performance bottlenec in tempdb - i.e. it is always experiencing allocation/deallocation waits, them multiple tempdb data files are not needed. If you do have this...

In a world of what appears to be absolutes, the illusion of control or lack of it, one will be the most successful when they learn to both see and...

03/23/2009 - 9:50 AM CST

The resource could not be found

Sorry, we could not find the resource at http://www.sqlservercentral.com:80/contest/

If problems persist, please contact us to let us know.

Definitely an interesting article Steve ... alot in a little to 'chew on' from both an ethical and a personal morals and values point of view.

However MS just plain blew...

Lacking a trace I'd start to investigate T-SQL jobs that backup or possibly reindex databases. Sometimes homegrown scripts contain these 'goodies'.

websites like SSC, discussion groups, BOL, 'old fashioned' books and the like are great resources. However there is one important piece of the puzzle missing, that is a mentor. This...

Double check the recovery mode of the database. The output states the TLOG portion failed - if the database is in 'simple' recovery mode that could explain it.

In order to answer this question easily and correctly we'll need 3 things.

- The backup script that you used.

- The restore script that you used.

- The error...

They have my vote Steve 🙂

You’ll take my 'snooze' button when you pry it from my cold dead fingers 😛

What technology has really improved your efficiency?

WOW !!! There have been so many over the last 25 years that come to mind that have made contributions to productivity at different...

have you tried to 'ping' things to see what your network is doing ?

Regardless of the discrepancy, 249 or 999, any design that requires anywhere near that theoretical maximum, is most probably a 'pile of dung' !

Running an application database in 'compatibility mode' for SQL 2000 is not all that bad. You will still reap the performance and tools gains of the release. You'll just lose...