What is mssqlsystemresource? It is the Resource Database, a read only database of system objects that makes upgrading SQL Server much easier.
SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL
Want to track down active transactions in your database? One simple DMV query on sys.dm_tran_session_transactions returns them in SQL Server 2005.
SQL SERVER – Clear SQL Server Memory Caches
Need to clear SQL Server memory caches on a production server you cannot restart? Three DBCC commands free up memory by cleaning the cache.
Change Service Broker Port: Drop and Recreate the Endpoint
Service Broker hit error 9692 because another application used its port. To change Service Broker port, drop the endpoint and create it again on a new port. Both scripts are here.
Organising Notes You Have Already Written
Learn to organise notes around problems, useful search terms, and review dates so earlier SQL Server work becomes easy to find and trust.







