Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...

Keeping in mind the importance of the cache mechanism, how could one get the plans and their usage statistics in SQL Server?  Read more...

Learning how to read and analyze execution plans takes time and effort. But once you gain some experience, you will find them an essential skill for getting to grips with performance issues in SQL Server Queries. Grant here describes the range of execution plans for different simple SQL Queries.  Read more...

Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.   Read more...