Article: SQL Server memory configurations for procedure cache and buffer cache
To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you’re using, whether it’s x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. I talk about how the system configures memory and how it allocates the amount of buffer and procedure cache that’s available.
SQL 2005 Internal Query Error 8623 still unfixed
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.
Back To Basics: Service Broker Queues
The service broker queue is where the messages are stored after they are delivered, but before they are processed. They are kind of like tables as you insert data into them (sending the message) and you view the data in them (receiving the message).
Back To Basics: Service Broker Contracts
Every Service Broker conversation requires a contract. The contract defines which message type or types will be used, as well as who (sender or receiver) can use which message types. The contract is specified when the conversation is created.