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.
Thanksgiving is tomorrow, spend the day with family.
I know that this is normally a technical blog, but with the US Thanksgiving day holiday coming tomorrow I wanted to be sure to point out that time needs to be made out of our busy work schedules to make sure that we spend time with our families. It’s very important that we find a […]