Tags » SQL Performance
For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way:
My biggest sins have been executing code against production environments when I thought I was pointing at my local machine: 1,898 more words
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts of a given query and to allow the SQL Optimiser to form efficient execution plans to delivery those query results. 1,274 more words
Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems. 489 more words
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve started using these, you may notice that once you start to troubleshoot longer scripts or stored procedures that reference lots of tables or have multiple queries, you start getting lots of output. 995 more words