Month: October 2008

By Posted on Posted in Classes No Comments Tagged with

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 recommendations for both the developer and the database administrator. Topics covered will include index usage details, query tuning, understanding the …

SQL Server Performance Tuning for the Bellingham .NET users group Read more »

By Posted on Posted in TSQL No Comments Tagged with ,

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) or varbinary(12000)? No. If you are going to specify an actual number instead of (max) then your limit is 8000. …

varchar(max) and varbinary(max) Questions and Answers Read more »