Archive for the ‘SQL Server’ Category

Query Optimisations Team Blog

For some time now I have subscribed to Craig Freedmans blog. The guy really knows his stuff and if you want to understand some of the gubbins(?) of the SQL query executions, plans  and processing, this is really worth a looksee.

In a post I saw today, There is a link to the SQL Query Optimization Team blog. I had not encountered this before but it looks like another goldmine of query optimisation  and execution tips – “providing tips, tricks, advice and answers to freqeuently-asked questions in a continued effort to make your queries run faster and smoother in SQL Server”

SQL Server and Trade Me

I went along to the Wellington SQL Server Users Group this evening, where we heard a great talk by a guy named Paul Gold.
Paul was the technology and database architect for www.trademe.co.nz, New Zealand’s equivalent of E-Bay, from 2001 to 2007, so he has seen the business basically from start up to its current position in the top 5 sites in Australasia, Alexa rates this site 436 in the world!
He had some very interesting things to say about performance issues, from both a SQL and an IIS perspective, when you get into high volume transactions as well as database structures and server farms / clusters.
I would say that my eyes have opened a little to the different requirements in database design when you need to do serious performance without doling out serious investment to do it – and how much denormalisation and removing expensive SQL commands can impact it (for expensive commands see OR and IN clauses and aggregates as given examples).

A most informative speech well worth the time. And hey – we got pizza too.

Anyway – the group meets every 3rd Thursday of the month. Last months talk was a very good talk on the new SQL Spatial enhancements for SQL 2008. So there looks to be a good variety of speakers. Watch this space for more updates.

Those ever productive folks at MS

The guys at the SQL Server 2005 Blog have just posted that the much anticipated (at least by me) SQL Server 2005 Performance Dashboard Reports are now available here.

“a set of Reporting Services reports that will help DBAs diagnose potential performance problems. These reports were designed to leverage the new Custom Reports functionality in SQL Server Management Studio (Service Pack 2)”.

I look forward to trying these out :).

Thanks guys.

One for those of us who care – SQL Server 2005 Best Practices Analyzer now available

From the Guys at the SQL Server Manageability Team Blog

 SQL Server 2005 Best Practices Analyzer (February 2007 CTP)–Now Available