Thanks as ever for your comments.

Some of the books I've read on the subject do mention that house building is a bad analogy for agile development but I couldn't think...

I thought that clustered indexes have to go on the same filegroup as their table in any case.

I would look to put the larger indexes on their own filegroup and...

Bounce your records into a temporary table with an identity field on it.

Then do something similar to the pseudo query below

UPDATE DEST

SET DateTime = DATEADD(mm,T.ID-DT.FirstID,GETDATE())

FROM dbo.YourTable AS YT

INNER JOIN...

If you have the chance then use international/national standards for your geographic codes. You would be surprised by how many different every day entities DO have an ISO standard.

Obviously...

If it ain't broke, don't fix it!

If you are running SQL2000 and your boxes aren't stretched then where is the pressure to upgrade?

There are some features of SQL2005 that really...

Good article.

For me one point jumps out. The attendees were quite good at prioritising for themselves!

My experience is that 99.9% of people are reasonable, are willing to give something...

In the ideal world I would agree with you entirely. Block them at the firewall and remove db_datareader/db_datawriter access.

However the problem described in the article was of a business...

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