So what’s the difference between null and a blank field
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 hard to deal with”, “I […]
Temp Tables, Table Variables, and CTEs
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 SQL Server does not place locks on table variables when the table variables are used. Temp tables allow for multiple indexes to be created Table variables allow a single index […]
A well timed code freeze is critical to keeping your sanity.
Doing a code freeze at this time of year can be crucial to keeping your sanity this time of year.
SQL 2008 November CTP
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 you get […]