Run the trace without using the profiler. The profiler GUI slaughters performance.

Where separation in 'n' tier applications CLR functions have little use because each component is a specialised resource.

Where the SQL Server is more of a one-stop-shop then the CLR functions...

In the short term I would run a trace.

Other ways are to use the following to write to the Windows event log.

RAISERROR('Procedure name xxxxxx ran',10,1) WITH LOG,NOWAIT

You can have the...

This a question to which the answer is "it depends".

The only way of telling is by using DBCC SHOWCONTIG to see how fragmented the tables are.

If you have tables on...

I learnt to play the piano at the age of 5 and one of the first things they teach is how to hold your hands and wrists.

So far I have...

Perhaps we are going about this the wrong way.

I should like to suggest that Red-Gate make a sample application available to SSC members with the precise intention of getting SSC...

I use the RedGate products and find that they do speed things up.

There is a layout file used SQL Refactor that can be edited to give you the layout you...

I'll look into it Marc. It should be possible but there is one thing I have found with SQL2005 and system tables. Basically you can't query them directly,...

I must admit I am somewhat ambivalent to storing XML in a relational database.

If I am going to store XML data it is because I want to retrieve it in...

From past experience I would say that budget constraints make a proper test hard to carry out in many shops.

You may be able to proove that a backup can be...

Which is which?

Thhe version of BOL I mean not the Bible. I'm not opening up that can of worms!

I don't really have any more to add than what is in the post. I need to pin it down further before I have enough to go into an...

BOL isn't the most accurate set of documentation on the planet!

Use Thunderstone's Webinator.

I used it on http://www.adviceguide.org.uk and http://www.citizensadvice.org.uk

SELECT @dtStoptime = CONVERT(DATETIME,CONVERT(VARCHAR(11),GETDATE(),120)+ '23:59:59.999',120)