Tag Archives: Development

Is This Your First Time Here?

by Mike Walsh on 12. Jul, 2010 in

First of all, Welcome to my SQL Server blog! I’m glad you decided to check it out. I hope that you are able to find everything you need here, if not (or if you just want to say, “hi”) please feel free to leave a comment below. I try to respond to all comments on [...]

  • Share/Bookmark
Read full story • Comments { 0 }

Just add a join hint!

by Mike Walsh on 20. Feb, 2009 in Performance, Pet Peeve, Syndicate

When I posted about Empirical Evidence and finding a Troubleshooting Methodology, I talked about implementing a solution just because it seemed to work. This can manifest itself in different ways. Some are alright and harmless (what your shotgun hit happened to be the right fix) and some can be dangerous and hide the real problem.
One [...]

  • Share/Bookmark
Read full story • Comments { 0 }

Good use for WITH RECOMPILE

by Mike Walsh on 31. Dec, 2008 in Performance, SQL Server 2005, Syndicate

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 [...]

  • Share/Bookmark
Read full story • Comments { 0 }