Nice article, well written. As a developer that has had to do a lot of work around date and time functionality, I can appreciate this article. You are correct that...

Well, I can't say that I 've ever had the need for 2100 parameters in a stored procedure, but I have built and worked on some fairly large systems. One...

For anyone who is interested, I found what looks to be a decent Speed Ferret replacement program:

It's called SQLServerFind 3.3.2. It isn't free, but close. $11.00 US or 10 EURO.

Looks...

I read your article with great interest, hoping beyond hope to find a search and replace tool.

I've been using Black Moshannon Systems program called Speed Ferret 4 for many years....

The problem is that when you issue this command:

SELECT @CMD='SELECT * INTO ##TEMP_TABLE FROM '+@TABLE_NAME+' ALTER TABLE ##TEMP_TABLE ADD TAB_ID_MARKER INT IDENTITY(1,1)'

where @TABLE_NAME references a table with an already existing...

What about shrinking TLog files? (SQL2K)

We a few months back we started getting "disk space low" errors on a very large drive hosting the TLog files for the SQL Instance....