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 format your code for you, correcting tabs, lining...
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 functionality to match an existing report they've...
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 LDF. Is there a way to separate these so that the...