Similarly, I know that using count(fieldname) vs count(*) can cause a problem. By using count(*), SQLSvr's optmizer determines the best field to use based on primary keys/indexes. However, you may have...

Thanks for the good suggestions. I agree the programmers should trap code if the query is repeated, but that will be hard to implement here. I'm not sure how this...

Perhaps tracing sp_spaceused or sp_helpdb exactadb would get you there.

One more bit of information about my scenario: I used a script to restore the database, which would create the database and then restore it. Perhaps if I had used...

So, to calcualte the space for a nonclustered index on colA, you would basically use the same calculation for the colum's data -- something like (size of colA datatype multiplied by...

try...

Select table_name from information_schema.columns where column_name like '%text%'

I will try the hard cap and post my results. Thanks!

Thanks everone.

No, I don't have a hard cap on the SQL memory usage. The default setting is set (so that it dynamically determines/grabs what it needs). It's really a default...

Below is a free and excellent script written by Narayana Vyas Kondreddi who has a nice site full of useful SQL scripts and information http://vyaskn.tripod.com. To use it, execute

EXEC sp_generate_inserts @table_name='Zone_Num',...

Wz700, thanks! The COLUMNS_UPDATED() conversion part was my problem. I'm new to working with that and couldn't find any good examples. I'm surprised that SQL Server doesn't have a more...

By the way, I had to modify the trigger slightly to handle INSERTs as well as UPDATEs. The JOINs worked fine for updates because both the inserted and deleted tables contained records....

Thanks to all for pointing out these things, which was exactly what I needed. It was indeed updating only the current row, which would have been ok in my scenario...

Thanks to all for the respones. Please don't misunderstand me. I do actually believe cursors are good and do consider them. However, I tend to 95% of the time envision a set-based technique...

I agree that it's not a good idea to turn on the "ignore duplicate" option, however, I was just using this feature temporarily as a simple way to insert unique...