This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Object Explorer results window.

SQL SERVER – mssqlsystemresource – Resource Database

July 27, 2008
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL System Table

What is mssqlsystemresource? It is the Resource Database, a read only database of system objects that makes upgrading SQL Server much easier.

Read More
SQL SERVER - 2005 -Track Down Active Transactions Using T-SQL

SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL

July 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table, SQL Transactions

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.

Read More
SQL SERVER - Clear SQL Server Memory Caches

SQL SERVER – Clear SQL Server Memory Caches

July 22, 2008
Pinal Dave
SQL Performance
SQL Scripts, SQL Server DBCC

Need to clear SQL Server memory caches on a production server you cannot restart? Three DBCC commands free up memory by cleaning the cache.

Read More
SQL SERVER - FIX - ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

July 21, 2008
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Error 9004 means an error occurred while processing the log for database, so it will not attach. Here are the steps that worked for me, starting with emergency mode.

Read More
Diagram of two SQL Server instances, each with a Service Broker holding Message, Contract and Service, joined by a dialog conversation; the two BrokerEndpoint boxes talk over TCP and the LISTENER_PORT value 5000 is marked in red

Change Service Broker Port: Drop and Recreate the Endpoint

July 20, 2008
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts, SQL Server

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.

Read More
SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

July 19, 2008
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Error Messages, SQL Scripts

Error 9692 says the Service Broker transport cannot listen on port because another process uses it. Find that program with netstat, or move the port.

Read More
Several plain paper folders arranged in a small wooden tray beside a closed notebook.

Organising Notes You Have Already Written

July 18, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn to organise notes around problems, useful search terms, and review dates so earlier SQL Server work becomes easy to find and trust.

Read More
Previous 1 … 306 307 308 309 310 311 312 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com