I too like EditPlus but I do my SQL code editing in SQL Server Management Studio. I add my code snippets to the Template Explorer. It has a...

I find either an interesting article or post every day in SSC. SSC is one of my major learning tools for SQL server. I have gotten many ideas...

If you believe Joe Celko the use of positional column numbers has been deprecated in standard sql:

http://books.google.com/books?id=Hi9fMnOoRtAC&pg=PA328&lpg=PA328&dq=sql+%22order+by%22+number+deprecated&source=web&ots=trcWSh_aWr&sig=FxKo5fDTZeMB0Y9RgRoEKqFYkFk

We conditionally bypass triggers for some batch processes on the production database.  We don't bypass triggers in the application.

Why don't you DISABLE/ENABLE the trigger instead of dropping it:

The trigger still exists but will not fire!

/** Only disable if client A **/

if exists (select * from dbo.sysobjects where id...

Jeff,

Thanks for the insight on Index usage and formulas in where clauses.  I guess I know better than to use SELECT * in production code.

Hi,

We have the same issue.  Notice that

SELECT * FROM blackhole WHERE DATALENGTH(singularity)>0

will give you the same result since DATALENGTH(NULL) is not greater than 0

If you also want to eliminate...

SELECT * FROM myTable

WHERE customerID = CASE

WHEN @customerID = myValue THEN myValue

ELSE customerID

END

Use suser_sname().  This should return the correct name.  I believe that the name returned by user_name() changed between SQL 6.5 and SQL7.   BOL tells you that user_name() returns dbo for someone...

Be aware that the Timestamp data type has been deprecated.  In SQL 2000 and 2005 it has been aliased by ROWVERSION, a more descriptive name.  I would recommend adding a...

I've got one of those "non-hyphenated double-barreled surnames".  It sure is an inconveniance  when I get misfiled because the database only recognized the word after the last space as...

Nope - no Stat Holidays in the U.S. or Canada for ends of any months

Holidays can vary by city and state and year: 

Memorial Day (US) can fall on May 31...

Sending mail from a trigger is not recommended.  Triggers should be performed quickly since other things wait for completion of the trigger.  Sending mail is slow and frought with problems.  One...

Every table I have has a trigger on Update to track changes made to the record at the database level.  All tables have fields of "UpdatedBy" and "UpdateTime" which are...

It's a bad table design to put 2 values (first and last name) in a single field.  In my part of the country there are many 2 word last names...