Microsoft Announces SQL 2008 Launch Event
Microsoft has announced the schedule for the SQL 2008 launch event.
New Article: SQL Server encryption vs. hashing for data security
I’ve published a new tip over on SearchSQLServer.com entitled “SQL Server encryption vs. hashing for data security”.
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 […]