Every SQL Server database has at least two files ... you may need to shrink the file back to a manageable size. You should avoid shrinking your files on a consistent basis as it can lead to ...

Once you disconnect a database, you must restore it from its .MDF file in a process called "attachment." SQL Server offers two ways to attach the .MDF file: via the Management Studio program's ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

One reoccurring SQL Server question that I see: Why is my TempDB database so large ... growth in TempDB size, large spills happen from time to time causing those files to grow.

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...