SQL Server with Mr. Denny:

Development


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

December 10, 2007  8:00 AM

Temp Tables, Table Variables, and CTEs



Posted by: Denny Cherry
CTE, SQL, T/SQL, Table Variables, Temp Tables

There are some major differences between temp tables, table variables and common table expressions (CTEs).  Some of the big differences are: Temp Tables vs. Table Variables

  1. SQL Server does not place locks on table variables when the table variables are used.
  2. Temp tables...


December 3, 2007  8:00 AM

SQL 2008 November CTP



Posted by: Denny Cherry
Beta, CLR, Installation, SQL Server 2008

We'll I've finely gotten around to installing the SQL 2008 November CTP.  While walking through the installer I have seen some excellent changes.  Not only is the option to change the paths of the data files no longer hidden, there are more than just two options.  There are at least 7 paths that...


November 28, 2007  7:38 AM

What’s up with the N in front of string values?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

If you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this. SELECT * FROM...


November 26, 2007  7:35 AM

Should I be using uni-code data types?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

The path that Microsoft is going says yes.  They are moving all there samples and defaults to using uni-code.  In reality uni-code may not be needed in your environment.  If you are storing only Latin characters (the US alphabet characters) then you probably don't need to store uni-code...


November 19, 2007  8:00 AM

Microsoft Announces SQL Server 2008 November CTP



Posted by: Denny Cherry
Beta, SQL, SQL Server 2008

Microsoft announced at TechEd in Barcelona, Spain that the SQL Server 2008 November CTP would be made available this month.  Read more here. ---> Update... Microsoft...


November 15, 2007  7:23 PM

New tip published: Update SQL Server table statistics for performance kick



Posted by: Denny Cherry
Article, SQL, Statistics, T/SQL

I've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


November 5, 2007  8:00 AM

What is the BACKUPTHREAD wait type?



Posted by: Denny Cherry
Recovery, SQL

If you have ever seen the BACKUPTHREAD wait type in the sysprocesses table or sp_who2 output and wondered what it is, I have found the answer. The basic explanation is "Used when waiting for a backup thread to complete.  Wait time may be very long (minutes, hours)."  Basically what this means...


October 31, 2007  6:09 AM

What is Service Broker?



Posted by: Denny Cherry
Service Broker, SQL

Service Broker is a transaction message queueing system build into Microsoft SQL Server.  It provides you with in order, guaranteed single read, message processing that is handled and managed with T/SQL code.  This makes it extremely easy to send and process messages either within a single...


October 29, 2007  8:00 AM

Easy way to read XML execution plans.



Posted by: Denny Cherry
Execution Plan, SQL

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.


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: