Tag Archives: tempdb database
-
SQL Homework – November 2021 – Backup, restore, and move the system databases.
2November 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 -
Querying temp tables across a linked server.
2March 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 -
SQL Homework – March 2019 – Reconfigure tempdb
Leave a commentMarch 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 -
More Collation Confusion. (tempdb)
1November 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 -
Start SQL Server without tempdb
3January 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 -
Model database
Leave a commentJanuary 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
SQL Studies 