SQL Server Education (by the geeks, for the geeks)
Hi Geeks, Think of a situation when you want to apply query hint to a query that is part of application code but development team is unwilling to touch application code. …
SQL Server plan guide and execution plan Read MoreHi Friends, This is my 3rd post in this series, “Plan Freezing & Plan Guides”. Last 2 posts can be found here: Part I; Part II; In my last 2 posts …
SQL Server: Plan Freezing & Plan Guides in SQL Server 2008 – Part III Read MoreHi All, In my last post, I talked about the basics of Plan Freezing. And i gave an example of a query that gets migrated from SQL 2005 environment to SQL …
SQL Server: Plan Freezing & Plan Guides in SQL Server 2008 – Part II Read MoreHi Friends, I recently delivered a session on SQL Server 2008 plan guides to a bunch of DBAs at my client’s location. This session was very well appreciated by the attendees …
SQL Server: Plan Freezing & Plan Guides in SQL Server – Part I Read More