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.
