Month: October 2008

SQL Server Performance Tuning for the Bellingham .NET users group

Tonight I had the opportunity to present to the Bellingham .NET users group.  About 30 people showed up for the presentation.   SQL Server Performance Tuning and Advanced Query Tuning: This presentation will include SQL Server performance tuning tips and

Tagged with:

varchar(max) and varbinary(max) Questions and Answers

The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2 ^ 31 – 1 bytes or just about 2gb.   Can I specify a varchar(9000)

Tagged with: ,