Tag Archives: tempdb database

  1. SQL Homework – November 2021 – Backup, restore, and move the system databases.


    November 2, 2021 by Kenneth Fisher

    On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points …
    Continue reading

  2. Querying temp tables across a linked server.


    March 14, 2019 by Kenneth Fisher

    And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
    Continue reading

  3. SQL Homework – March 2019 – Reconfigure tempdb

    Leave a comment

    March 4, 2019 by Kenneth Fisher

    You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor …
    Continue reading

  4. More Collation Confusion. (tempdb)


    November 8, 2017 by Kenneth Fisher

    I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
    Continue reading

  5. Start SQL Server without tempdb


    January 20, 2016 by Kenneth Fisher

    tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
    Continue reading

  6. Model database

    Leave a comment

    January 28, 2013 by Kenneth Fisher

    Most DBAs have at least some idea what the system databases are for. Master has the list of databases & …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013