Stop trying to shrink tempdb files
Why shrinking tempdb is usually counterproductive, and how to keep its data files at sensible sizes.
Continue readingBrowse the archive
TempDB
Fixing tempdb: Growing, shrinking, and removing data files
Fix tempdb file sizing problems by bringing data files to consistent sizes and managing growth.
Continue reading
Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?
Question SQL Server System Databases, as far as I know, always have those same IDs and I have seen lots of maintenance scripts on the internet relying on the predicate WHERE database_id > 4 to exclude them from the actions of the script.
Continue readingCannot connect to my SQL Management studio after moving a tempDB
Question In quite a bad position here. This afternoon on my tempDB I ran the query: sp_helpfile to locate where my MDF and LOG file were. My MDF was on my C: drive and my LOG file was on a D: drive so I've run the following query to move this Log file from …
Continue reading