Atlanta .NET Regular Guys

Community Blog for two guys in Atlanta that focus on Microsoft and Community.

Browse by Tags

All Tags » Microsoft SQL Server 2005 (RSS)
Shape up that SQL code
Have you ever worked on some of those one and two thousand line stored procedures where the indentation was so messed up you couldn't really tell where that left outer join fit in? Wouldn't it be nice if there was a tool out there which would automatically...
Chris Hays's sleazy "continued" hack almost works
Chris Hays posted this blog post about repeating group headers on each page, having them say "MyGroup (continued)" on all but the first page. This post went up Sept 27th and was a great stroke of luck on my part b/c my current client really wanted this...
Default data and log file paths in SQL Server
It's well understood that you shouldn't have your MDF and LDF files on the same spindles if you want to maximize IO performance. Unfortunately, you can only specify a default location for the SQL Server "data files", which includes both the MDF and the...