Stage I

DBCC UPDATEUSAGE

UPDATE STATISTICS (with FULL scan) for all tables

exec sp_recompile for all objects

exec...

You can also view them in Profiler .

When you set up a new trace ,

Go to the Events Selection Tab , Expand the performance tab , check ShowPlanXML

Excellent , I have found the articles written by Jeff , to be very useful

I agree that 1 transaction log is the way to go - but there are occassions , in emergencies when space issues , allow some flexibility in defining more than...

I agree that 1 transaction log is the way to go - but there are occassions , in emergencies when space issues , allow some flexibility in defining more than...

Also consider 1)changing recovery model

2)use TABLOCK

As well as the above suggestions , are you certain it's a database issue ?

Have you run a trace , to see if there are other issues regarding delays?

Is the...

We've just had to implement the 2 transaction log files for dealing in space issues- works very smoothly. Although it won't improve performance

We've just had to implement the 2 transaction log files for dealing in space issues- works very smoothly. Although it won't improve performance

The statement I'm running from Query Analyzer is :

SELECT myCo1,myCol2 FROM myTable

INNER JOIN MyTable2 ON myTable.thecol = myTable2.thecol

Is there a specific event that would display the COMMIT...

Thanks for the reply , with the figures I sent across there is just the 1 sql server statement , which I'm confused about the disparity between the the statement...

Have you tried a REINDEX ?