Tag Archives: Development
Finding a Straight Path For SQL Server Points of Pain

SQL Server Consulting – Straight Path Solutions

July 12, 2010 • Categories: • by

Welcome To Straight Path Solutions

As a consultant to the company, I worked directly with Mike for approximately one year. We worked as part of a team in a challenging software development environment with aggressive deadlines and many moving pieces. As a Database Administrator, Mike was a strong contributor and key to our success. As the [...]

Comments Off

Just add a join hint!

February 20, 2009 • Categories: Performance, Pet Peeve, Syndicate • by

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

0 Comments

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