SQL Server with Mr. Denny:

T/SQL


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

April 28, 2008  9:00 AM

Checking free disk space from T/SQL



Posted by: Denny Cherry
SQL, T/SQL, xp_fixeddrives

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...


April 21, 2008  9:00 AM

Back To Basics: The DELETE Statement



Posted by: Denny Cherry
DELETE statement, SQL

When you have data in your table that you need to remove the DELETE statement is the way to do that.  Using the DELETE statement without any WHERE clause will remove all the data from your table.  The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...


April 3, 2008  11:00 AM

New INSERT syntax in SQL Server 2008



Posted by: Denny Cherry
INSERT statement, SQL Server 2008, T/SQL

One of the very cool new feature which SQL Server 2008 gives us is an change to the INSERT statement.  Now you can specify multiple rows to insert into a table from a single insert command. The syntax is: CREATE TABLE TableName (Column1 INT, Column2 VARCHAR(10)) INSERT INTO...


March 31, 2008  10:00 AM

Back To Basics: The UPDATE Statement



Posted by: Denny Cherry
Back To Basics, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL, UPDATE

After you've inserted the data into the table, it's time to update the data.  We do this by using the UPDATE statement.  The update statment can be used in two ways.  The first is to update a record or set of records in a single table, by simply filtering the data in the table by using values...


March 24, 2008  10:00 AM

Back To Basics: The INSERT Statement



Posted by: Denny Cherry
Back To Basics, INSERT statement, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL

While the SELECT statement is probably the most important command, the INSERT comes in handy.  The INSERT statement is used to do exactly what it sounds like, it inserts data into a table.  There are two ways to insert data into a table.  The first is to pass in each of the values, and the...


March 17, 2008  11:00 AM

Back To Basics: Using Common Table Expressions



Posted by: Denny Cherry
Back To Basics, Common Table Expressions, CTE, SQL, SQL Server 2005, SQL Server 2008, T/SQL

CTEs (Common Table Expressions) are one of the very cool features introduced in SQL Server 2005.  In there simplest most common form, think of them as a temporary single use view who's context is only within the command which follows them directly.  The syntax of a CTE is very...


March 10, 2008  10:00 AM

Back To Basics: The SELECT Statement



Posted by: Denny Cherry
Back To Basics, SELECT statement, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL

There are four basic commands in databases.  They are SELECT, INSERT, UPDATE and DELETE.  Probably the most important of these is the SELECT command.  The SELECT command is how the data in the database is retrieved and displayed. (All these code samples can be run on all versions of Microsoft...


January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition



Posted by: Denny Cherry
DR, Log Shipping, Replication, SQL, T/SQL

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise Edition on both the machines.  This makes the solution fairly expensive.  Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...


January 7, 2008  8:00 AM

XML in the database. What’s the big deal any way?



Posted by: Denny Cherry
Data Types, T/SQL, XML

So, we've had the ability to use XML within the SQL Server databases since SQL 2000 came out.  What's the big deal you ask?  How can I use it to make my life easier you also ask? When I first started looking into this whole XML thing I was thinking the same thing.  How is this blob of data...


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: