Firstly, I would replace the DELETE FROM statements with TRUNCTATE TABLE statements. These are faster and won't generate the same amount of log file activity.

Secondly, replace your SELECT INTO...

My issue is that CLR (MFC with a fancy badge on it) allows programmers immense powers within my databases but I am not convinced that there is the corresponding corporate...

CREATE TRIGGER tr_FromTrainersTable ON FromTrainersTable FOR UPDATE

AS

IF UPDATE(Day1)

UPDATE FromTrainersTable

SET TimeStamp1 = GETDATE()

FROM FromTrainersTable INNER JOIN inserted ON FromTrainersTable.FTKey = inserted.FTKey

WHERE FromTrainersTable.Day1 ...

I could be wrong here but I thought that the cluster services required a domain account and thus SYSTEM would be disabled.

You can use the COLUMNS_UPDATED() function to determine if a column has been updated however this simply tells you that a SET operation has been carried out against the column,...

If you are trying to generate a web page from a stored procedure then use sp_makewebtask.

If you are trying to call a web page as you would for a web...

Like PHP, MySQL seems to have been written by a bunch of people who thought "what is missing from all web creation languages and how can we put all the...

As we all know the product as Yukon why not stick with that name?

When you brand a product by the year of release even the name has obsolescence. If...

OK, I worked on a database that had several million transactions per country per week appended to a database. I established a rule early on that said only one...

My personal preference follows the 80:20 rule. 20% of the data caters for 80% of the needs. Therefore I prefer to have a small amount of live data...

Has anyone changed the recovery mode of your database to simple?

Let us suppose that you develop on a case sensitive server and that development includes a substantial amount of data, that is, more than you would want to insert using...

I have to admit that I still look at an XML document as a posh version of a COBOL data division.

I quite like the ideas behind OOP and when it...

My wife took one look at a 42" plasma screen and said "it takes up less room than our existing one and will require less dusting".

What a woman!!!!!

It's a shame...

Will we be able to chip it and use it as a cheap web server