Category Archives: MS SQL Server

You can easily put a database into or take it out of single user mode with the following T-SQL: ALTER DATABASE  [MyDatabase] SET SINGLE_USER WITH NO_WAIT GO ALTER DATABASE  [MyDatabase] SET MULTI_USER WITH NO_WAIT GO

Here’s a quick way to get some timing statistics on your T-SQL: DBCC FREEPROCCACHE GO DBCC DROPCLEANBUFFERS GO SET STATISTICS TIME ON GO — Insert your query here SET STATISTICS TIME OFF GO After you run the statements in query … Continue reading →

How to Shrink Your Database Transaction Log If you have noticed that your transaction log on your SQL Server database has grown incredibly large after a long transactional process, you can try this to shrink it back down: DBCC SHRINKFILE(mydatabase_log, … Continue reading →