Firstly, is your 80 column table normalised? If you can have a greatly varied set of update routines then it sort of suggests that the table design could...

Running the GUI profiler will absolutely cane your server. The command line utility has a much lower overhead.

OBJECTPROPERTY and OBJECT_ID

I could be wrong, it has been known before.

I read somewhere about user defined functions that they have to be evaluated on a row by row basis. ...

If calling a function results in row by row processing wouldn't it be better to resort to the old fashioned

IF EXISTS (SELECT 1 FROM dbo.SysObjects WHERE Type='U' AND Name='Customers')

Thanks, I've seen the option and it produces a /~Z string but not the individual parameters.

As BOL says that the user name and password options can be encrypted I was...

Make large cup of non-decaff coffee

I would put check backups first closely followed by check disk space and current server activity.

I have my...

http://support.microsoft.com/?kbid=815495

I have been running the 818 hotfix for over a year now with no problems.

I thought SP3 was replaced with SP3a in any case and therefore you cannot download SP3.

The...

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...