We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles.
Report Caching and Snapshots in SSRS
Report caching and snapshots in SSRS reduce repeated database work when freshness rules, parameter combinations, and schedules are clear.
The First Hour on a Server Nobody Can Explain
Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.
SQL SERVER – Find Statistics Update Date – Update Statistics
Stale statistics can hurt a query plan. Use STATS_DATE to find the statistics update date for each index, then update them if they look outdated.
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
What is estimated I/O cost, what is estimated CPU cost, and why do these costs in an execution plan have no unit? I answer these common training questions.
SQL SERVER – Initializing a Merge Subscription Without a Snapshot
Books Online says initializing a merge subscription without a snapshot may be deprecated, while the transactional version has no such note. Plan for it.
SQL SERVER – Find Busiest Database
How do you find the busiest database on a SQL Server instance? I use sys.dm_exec_query_stats to add up logical reads and writes for each database.