TechTalk: Optimizing SQL Server 2005

I held a TechTalk on optimizing SQL Server 2005 on the 21st of January. I think it went well so I'm looking forward to the evaluations - please fill them out :)

I have put up the slides, code and test database backup for you to download:
Slides + Code
DB Backup (12mb)

Note that the slides are in Danish - sorry non-danes.

As I mentioned at the end of the TechTalk, I barely made it through all of my slides, and that's even after I sacrificed a lot of the topics & depth I wanted to talk about. Depending on the evaluations I get back, I'll probably be announcing a part 2 on this topic later on.

The tool I used to generate test data was Red Gate's SQL Data Generator. It's a great tool for quickly making a large set of test data so you can analyze the actual benefits of a properly indexed table.

kick it on DotNetKicks.com

Jan 22nd, 2009, 9:58 PM | Posted in .NET

Add comment

After you have posted a comment, an email will be sent to the provided email address. Before your comment is activated, you will have to click the confirmation link within the email.

Name:

Email (only used for validation):

Website (optional):

Message:

Notify me when new comments are added:

Please type the following letters into the box below:  

Post!