SQL Server with Mr. Denny:

June, 2008


June 10, 2008  6:39 PM

Article: SQL Server memory configurations for procedure cache and buffer cache

Denny Cherry Denny Cherry Profile: Denny Cherry

I've just published another tip over on SearchSQLServer.com.  This one is titled SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend

June 9, 2008  11:00 AM

SQL 2005 Internal Query Error 8623 still unfixed

Denny Cherry Denny Cherry Profile: Denny Cherry

While working on a new part of our production system  we begun getting the following error message back from the SQL Server. Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support...


June 5, 2008  11:00 AM

Back To Basics: Service Broker Queues

Denny Cherry Denny Cherry Profile: Denny Cherry

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).  While tables can have triggers, queues can...


June 2, 2008  11:00 AM

Back To Basics: Service Broker Contracts

Denny Cherry Denny Cherry Profile: Denny Cherry

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. The syntax for creating the contract is pretty...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: