SQL Server with Mr. Denny:

Data Normalization

1

March 12, 2014  5:00 PM

Learn Before You Plan



Posted by: Denny Cherry
Data Normalization, Database Administration, Database Design, Query tuning, SQL, SQL Server, SQL Server stored procedures, T/SQL, Tables

Walking into a new shop every couple of weeks has its challenges. What sort of problems are they going to throw at me. Recently I had the...

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


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: