Forum Replies Created

Viewing 15 posts - 331 through 345 (of 2,436 total)

  • RE: SQL Script for Countries, State, Cities

    Try checking out the US Postal Service website.

  • RE: Setting up TempDB

    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...

  • RE: It Depends

    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...

  • RE: New Monthly Contest Back!

    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.

  • RE: Almost Like a Service Pack

    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...

  • RE: Single mode to MULTI_USER mode

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

  • RE: Books OnLine?

    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...

  • RE: Backup Maintenance Plans failed

    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.

  • RE: restore problem

    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...

  • RE: Being More Productive

    They have my vote Steve 🙂

  • RE: Being More Productive

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

  • RE: Being More Productive

    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...

  • RE: time out error from sql server & windows server 2003

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

  • RE: Maximum No. of Indexes

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

  • RE: SQL 2005

    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...

Viewing 15 posts - 331 through 345 (of 2,436 total)