At the moment we have a very worrying situation on our production server. We cannot restore databases. Every time we try to restore a database, SQL...
While doing some performance testing with a stored procedure I am working on, I decided to try using a temp table in an effort to speed up part of...
I am sure this is a simple one, but for some reason my brain isn't working today... I am trying to concatenate several fields in a select statement,...
I am currently looking at using XML in one of the projects I am working on for my current client. My client uses SQL Server 7.0 and has no immediate...
What techniques can be used to re-write queries so that they do not use table spools? All the material I see mentioning query optimisation says that...
We have search capabilities in our web application which I am trying to improve the performance of. One aspect of the search (which we call "simple")...
You can make the code to calculate the selectivity of a column (from the latest newsletter) more useful by creating a stored procedure. Then it...
One of my colleagues recently asked me an interesting question which I was unable to answer: Is it possible to modify the priority of a single query?...
I have a query I am trying to optimise and I'm having a bit of trouble trying to figure out some wierd behaviour. The query was originally generated...
Separate names with a comma.
