Part 2 of my look at the computed column and its effect on storage, with a list of the earlier articles in the series on PERSISTED storage and performance.
SQL SERVER – Computed Column and Performance – Part 3
Part 3 of my series on computed column and performance shows how an index improves the performance of a computed column. Read the earlier parts first.
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
A query tuning visit turned into a lesson on why running SHRINKDATABASE for every database is a bad idea. Here is what happened at the client’s office.
Heap Tables: When a Table Without a Clustered Index Hurts
Find heap tables, inspect forwarded records and empty-page behavior, and choose between a clustered index and a planned rebuild.
SQL SERVER – Computed Column – PERSISTED and Performance – Part 2
Part 2 on PERSISTED and performance shows the other side: when non-persisted computed columns give better performance than PERSISTED ones.
SQL SERVER – Computed Column – PERSISTED and Performance
My computed column series in one list: PERSISTED versus non-persisted for storage and speed, and how an index on the column improves performance.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.