Archive | SQL Server 2005 RSS feed for this section

Good use for WITH RECOMPILE

December 31, 2008 • Categories: Performance, SQL Server 2005, Syndicate • by

Haven’t looked into all of the details underneath but at the surface probably a good reminder of where WITH RECOMPILE can be helpful…
Using SQL Server Reporting Services, a workaround was used (this is the part I want to look into more) to basically get a blank report showing when a user first links to a [...]

0 Comments

Rolling Back (or is it??)

December 31, 2008 • Categories: DMV, Linked Server, SQL Server 2005, Syndicate, Troubleshooting • by

Interesting Issue Today/Yesterday -
A query was using a linked server to grab data from DB2 via an ODBC connection. Normal execution time is about 15 minutes. This had run on for at least 7 hours when it was decided to kill it, appeared to be doing nothing but causing blocks (due to Intent Shared and [...]

0 Comments