SQL Server with Mr. Denny:

Data integrity

1

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

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


December 13, 2007  8:00 AM

So what’s the difference between null and a blank field



Posted by: Denny Cherry
Data integrity, Data Types, NULL, SQL, T/SQL

There is always a discussion going on somewhere over having NULL values in a database.  Some people (such as myself) are fine with NULL values.  Some people don't like having NULL values in there database for some reason.  I've heard all sorts of reasons; "The screw up performance", "They are...


1

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: