I wasn't being xenophobic when I mentioned Analyser, it is what the app is called in the hostname field.

I guess it is one of those "localization" things. Shades of...

This thread illustrates that there are many ways of writing exactly the same query.

I find that derived tables are fine up to a point, beyond which temporary tables perform better.

It...

Apart from the missing join predecate I would also start assessing how many records each of the participating tables have in them in total.

Are the actual table objects that are...

One aspect I forgot to include was when someone uses MS Office to connect to your databases. I'm thinking of MS Excel and the pivot report/charts. I haven't...

Not if you're British it shouldn't.

Sorin Petcu (1/15/2008)

---

The line:

INSERT INTO @InputBuffer(EventType,Parameters,EventInfo) EXEC (@SQL)

gave me an error:

Server: Msg 197, Level 15, State 1, Line 65

EXECUTE cannot be used as a source when inserting into a...

If the length of your ntext field is under 4000 characters then cast it to a VARCHAR and use the REPLACE statement.

This is a mamoth task. I would omit SQL6.5 from the presentation. In about 4 years time there will be DBAs working who were not born when SQL6.5...

Have you got a server somewhere where you can do a test restore of your backup. I know restoring system databases is a pain but for peace of mind...

See if this helps

http://www.sqlservercentral.com/articles/Administering/utilityprocedures/2272/

ISO8859 seems to refer to Latin character sets.

Can you give a specific example of what is going wrong?

I use XML EXPLICIT when I need a specifc layout but only when...

I deployment and rollback scripts for everything as a matter of course that way I know I have a way of installing and uninstalling software in a hurry if need...

I would create a table that holds a flag.

Have your trigger set the flag

Set up a schedule job that runs every minute or so with a task that says

IF EXISTS(SELECT...

SELECT *

FROM tblEmp

WHERE empjob=1

AND emprole <>'clerk'

Sad:

Just found out why it was so important to back up the database master key.

Forgot to put a WHERE clause on a DELETE/UPDATE.

Selfish:

Implements something in LIVE 5 minutes before leaving...