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 […]
New Article: Tricks to increase SQL Server query performance
I’ve published a new tip over on SearchSQLServer.com entitled “Tricks to increase SQL Server query performance“. Denny
What’s up with the N in front of string values?
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 sys.databases WHERE name = N’master’ What this N does is tell the SQL Server that the data which is being passed […]
Should I be using uni-code data types?
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 characters.