Tag Archives: performance

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count(*) from TableName but it has quite a nasty performance. Another way to do it with much […]

High Performance SQL Server – Complete showplan operators

My colleague Fabiano Amorim at SolidQ just published an interesting book about explaining Query Optimizer behaviour. How it works and how to understand it based on the behaviour of a small set of executions plan. Great reading and the best thing about it : the book is free to download at : http://www.simple-talk.com/books/sql-books/complete-showplan-operators/ Happy optimizing […]