June 9, 2008  11:00 AM

SQL 2005 Internal Query Error 8623 still unfixed



Posted by: Denny Cherry
Data integrity, Data Normalization, Error 8623, INSERT statement, Internal Query Processor, KB 940371

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



Posted by: Denny Cherry
Back To Basics, Queue, Service Broker, SQL

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



Posted by: Denny Cherry
Back To Basics, Contract, Queue, Service Broker, SQL

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...


May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem



Posted by: Denny Cherry
Service Broker, SQL, SQL Server 2005, TempDB

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


May 20, 2008  12:26 AM

EMC World 2008 Day 1 (Last post of the day)



Posted by: Denny Cherry
EMC World 2008, Remote Blob Storage Architecture, SQL Native Client, SQL Server 2008

I find myself with a little extra time between my last session of the day, which was a SQL 2008 Session, and the Grant Opening Reception, so I figured that a blog post was in order.  The SQL 2008 session was a what's coming in SQL 2008. Most of the information was stuff that I already knew and...


May 15, 2008  11:00 AM

Back To Basics: Service Broker Message Types



Posted by: Denny Cherry
Back To Basics, Message Type, Service Broker, SQL

The message type is the first of the service broker specific objects.  The message type defines the name of the message, and performs any validation that the service broker needs to do on the contents of the message prior to sending the message.  If the message is being sent to another database...


May 12, 2008  9:00 AM

Data Normalization, with storage being so cheap what’s the point?



Posted by: Denny Cherry
Data integrity, Data Normalization, SQL

Back in the old days one of the big reasons that people enforced such strict rules on data normalization was because it would greatly increase the amount of information you could fit on the hard drive.  Back when everything was measured in kilobytes or megabytes storing redundant information...


May 8, 2008  11:00 AM

Back To Basics: The SQL Server Service Broker



Posted by: Denny Cherry
Back To Basics, Service Broker, SQL

The SQL Server Service Broker is a fantastic new addition to SQL Server.  For those who have used Microsoft Message Queue (MSMQ) the service broker will be easy to understand as it's the same basic concept.  Messages are sent from one place to another, within a database, from database to...


May 8, 2008  4:04 AM

Quest Meet the Expert Video published



Posted by: Denny Cherry
Queue, Video

Quest Software has just published the first of a few videos which I recorded with them. You can download or view the video from here. I've...


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: