However David I would suggest monitor that site regularly. The reason you may have gained so much space back could have been due to the number of page splits that...

There is a typo in the SELECT code, needs to be

SELECT Particulars,

     LTRIM(RTRIM(SUBSTRING(

       /* <text>> */ Particulars,

       /* <start > */   CHARINDEX(';',Particulars,1) + 1,

       /* <length> */   CHARINDEX(';',

          SUBSTRING(Particulars,...

Actually appears to be by design. Check the comparison chart on this page http://support.microsoft.com/default.aspx?scid=kb;EN-US;214601 which refers to the behavior in 6.x and 7. Apparently still applies to 2000.

Look at...

Size can make a difference as can index matching methods. Please run

SET SHOWPLAN_TEXT ON

then your query right after that on each server and post the text output here which is...

There are many ways to implement a potential solution, many suffer under the strain of a large dataset. Sql 200 is based on the SQL 92 standards and thus does...

Unfortunately you cannot do anything to @var in the Stored Procedure as text, ntext and image cannot be altered within it. Never really found an example of why MS implemented...

I have done many ways. I personnaly use SP groups with business logic to decided the SP number in the group to run and of course comments to above each....

Sorry not that simple. You have to take into account if their birthday has been reached or passed. This works

DECLARE @birthday AS datetime

SET @birthday = '1983-10-04'

select DATEDIFF ( year ,...

I had the same problem last week, and tried various techniques as described above. I was given a piece very useful advice by our DBA....

...if you can, remove the clustered...

How many records are in each table?

Can you please specify in the future which version of a tool as the version shipped with SQL 7 has none of this functionality. 2000's version does. I got the...

Sounds like you have an application running over these tables and you are reporting. Usually the date is the number of seconds since Jan 1 1970. All you need to...

UTC date times are usually just date times based on UTC location. If it is something else then what are you seeing?

As you are wanting to remian in Truncate on Checkpoint the entire time do like so.

Maybe do a fullback to file beforehand for safety in case you find an error...

No, the Transaction Log will grow even if you have set to truncate on checkpoint. This is to ensure the DELETEs can all be rolled back should an error occurr...