December 15, 2007 5:38 AM
Posted by: Denny Cherry
Article,
Data Types,
Development,
SQL,
SQL Server 2005,
SQL Server 2008,
T/SQLI've published a new tip over on SearchSQLServer.com entitled "
December 13, 2007 8:00 AM
Posted by: Denny Cherry
Data integrity,
Data Types,
NULL,
SQL,
T/SQLThere 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
Posted by: Denny Cherry
CTE,
SQL,
T/SQL,
Table Variables,
Temp TablesThere 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
- SQL Server does not place locks on table variables when the table variables are used.
- Temp tables...
November 28, 2007 7:38 AM
Posted by: Denny Cherry
Data Types,
SQL,
Uni-codeIf 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
Posted by: Denny Cherry
Data Types,
SQL,
Uni-codeThe 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
Posted by: Denny Cherry
Beta,
SQL,
SQL Server 2008Microsoft 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
Posted by: Denny Cherry
Article,
SQL,
Statistics,
T/SQLI've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...
November 5, 2007 8:00 AM
Posted by: Denny Cherry
Recovery,
SQLIf 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
Posted by: Denny Cherry
Service Broker,
SQLService 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...
