I thought hotfix 8.00.818 which is supposed to be the SQL Slammer patch?

Yep,

They are an external (an theoretically neutral) department with no connection to the issues involved.  Effectively they are for external verification that you raised an issue and it wasn't dealt...

Put down your issues in writing in unemotional language.

E-mail said issues to your boss and copy in your HR manager.

Keep a copy where you know you can get at it.

If...

Anyone remember EDLIN and the F6 key?

The CMS I am using uses JavaScript and has a gc(); command to invoke the garbage collector.

I haven't got that far into VB.NET yet but I'm sure that there will...

A good tool makes a hell of a difference to the productivity.

I don't like the way Interdev and Frontpage bloat the code, and yes, I too used notepad for web...

I seem to remember an article somewhere on this site that said that SA use, not just access, should be avoided where possible.

If I was in the situation where I...

3 steps forward 2 steps back then

One thing I am not clear on with garbage collection (whether in Java, .NET etc) is when is...

I like Kalen Delaney's idea to use case sensitivity in a development environment.

I inherrited a database that isn't particularly well normalised and is case sensitive.

The problem comes at the user...

If I have a database dependent external process then I usually use a trigger to insert records into a logging table or tables.

For example, a new page gets published in a CMS...

SQL Injection attacks happen due to a violation of basic programming principles.

As a matter of good programming practice

• ALWAYS validate user input.
• ALWAYS check that data cannot exceed its bounds  i.e. the...

I have to say that they are all better than anything that I could have managed.  If I had to choose from the six on offer then it would either...

sp_refreshview recompiles the view which achieves the same thing as running an ALTER statement

How about checking to see if the new column is actually needed?

Look at the design of what is there already and ask if it can encompass the need without the...

SELECT INTO is slow, horrendously slow on retrieving large recordsets.

Creating the table first, then doing and INSERT INTO is much faster, plus you have greater control over the table structure.

I...