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

Interesting!

I thought that hierachal databases were making a come back for very large databases because of their performance advantages.

Are XML databases hierachal?

Do you know if there are there any OO...

When you create a temporary table its name is always unique.

You think you have created #Tbl_MyTable and to all intensive purposes you have, but the real name will be #Tbl_MyTable_____...._DE...

I know that temporary tables are stored in tempdb but where are tables stored in a "table" data type stored?

In the case of some of one of our CMS's there is always some database traffic but the initial traffic is to determine if the object in the database is...

We use a variety of content management systems and the approach that they take is to cache the results of a query in their own internal cache.

Another approach that we...

Statistics and military intelligence share a characteristic that they should be used as as a predictive tool or indicator to say what is likely to happen.

They shouldn't be used to...

Frank,

You know when you are trying to teach your kids to behave properly part of it is getting them to speak properly (and the rest is teaching them when to...