We are running SQL2005 SP2 and erratically (sometimes less than once a week other times once or twice a day) we get a flurry of timeout errors for no...
I'm currently rewriting some fairly old and complex stored procedures originally written in SQL2000 that I believe can be simplified using SQL2005...
Refers to http://www.sql-server-performance.com/tips/t_sql_where_p1.aspx The advice given here will return incorrect results SELECT column_name...
We have a finance database model that we have used for a few years for one client. We now wish to use the model for multiple clients. We have...
I was somewhat surprised by the following behaviour. IF (0 = '') BEGIN PRINT '0 = ''''' END ELSE BEGIN PRINT '0 <> ''''' END Is there any server...
How can I do this (SQL 2000). I have a stored procedure that accepts a text parameter (@BodyText). I only want to store this if it is different...
Hi, I've read the advice herehttp://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp on this site concerning Total Server...
Hi. I have a query that is bugging the hell out of me! It is one of the worst performing queries in my application. I have ended up kind of fixing...
Separate names with a comma.
