Monthly Archives: 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

Posted in Classes 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)

Posted in TSQL Tagged with: ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: