rbarryyoung (6/18/2008)

Aren't the first two affected by configuration settings on the server or...

I would suggest to move TEMPDB on yet another separate drive. One drive for data, one for logs, one for TEMPDB, that worked best for us.

It is hard to describe what to do, if we don't know anything about the procedure (what columns are returned, what can be used as a key for joining to...

As far as I know, the main difference is, that SET makes this setting valid for all subsequent operations (until it is re-set or connection closed), while WITH(...) sets the...

Hello,

if the column txt_alt is defined as case sensitive (see "Collations" in SQL Server Books Online), you can use the function LOWER to find, whether there are some capital letters...

Jeff,

calculated column was my first idea, but when I tested it, I found out that it can't be made persisted because of ISDATE function (and also probably can't be indexed...

Well, that's true, but on the other hand, where are you getting the "BrokenDate" from (during the INSERT ... FROM inserted inside the trigger)? That is, what datatype is "BrokenDate"?

If...

Gail,

did you test your INSTEAD OF trigger? I tried to do it approximately the same way, but it didn't intercept the error. I was still getting the conversion error message......

This is how I would probably go about such problem...

You will need to have 2 columns in the table for this date - one datetime and one varchar. Then make...

There are many possible ways to achieve your goal... You can find a pretty detailed description here:

Arrays and Lists in SQL2005

or, in case you have SQLS2000 and posted in a...

Something very similar was discussed several times during the last few days.

This is one of the threads:

Dynamically choosing inner or outer join

I think that similar approach could work for you...

Sorry, but as far as I know, it isn't possible... we only needed such out-of-range dates once, and that was only for storage (no calculations performed on the column), so...

jcb,

this is one of my favorite links - it discusses how to apply various search criteria, and mentions many possible solutions, their advantages, drawbacks and performance. Maybe it will help...

Jeff is absolutely right, use of ISNUMERIC is limited, it will miss many values. You can try it - if it helps, great; but you can't be sure it finds...

Depends on what your procedures look like, but you could find some useful info here: http://www.sommarskog.se/. It isn't a book, but it is a source of interesting information and helped...