I’ve often found that
the kind of tips that turn out to be helpful are
the ones that encourage me to make a small step outside of a routine. No dramatic changes – just a quick suggestion that changes an approach. As a languages student at university, one of
the best I spotted came from outside
the lecture halls
and ended up saving me time (and lots of huffing
and puffing) –
the use of a rainbow of sticky notes for well-used pages
and letter categories in my dictionary. Simple, but armed with a heavy dictionary that could double up as a step stool, those markers were surprisingly handy.
When
the Simple-Talk editors told me about a book they were planning that would give a series of tips for developers on how to improve database performance, we all agreed it needed to contain a good range of pointers for big-hitter performance topics. But we wanted to include some of
the smaller, time-saving nuggets too. We hope we’ve struck a good balance.
The 45 Database Performance Tips eBook covers different tips to help you avoid code that saps performance, whether that’s
the ‘gotchas’ to be aware of when using Object to Relational Mapping (ORM) tools, or what to be aware of for indexes, database design,
and T-SQL.
The eBook is also available to download with SQL Prompt from
Red Gate. We often hear that it’s
the productivity-boosting side of SQL Prompt that makes it useful for everyday coding. So when a member of
the SQL Prompt team mentioned an idea to make
the most of tab history, a new feature in SQL Prompt 6 for SQL Server Management Studio, we were intrigued. Now SQL Prompt can save tabs we have been working on in SSMS as a way to maintain an active template for queries we often recycle. When we need to reuse
the same code again, we search for our saved tab (and we can also customize its name to speed up
the search) to get started.
We hope you find
the eBook helpful,
and as always on Simple-Talk, we’d love to hear from you too. If you have a performance tip for SQL Server you’d like to share, email Melanie on
the Simple-Talk team (
[email protected])
and we’ll publish a collection in a follow-up post.
