Yes, that is primarily why I went the way I did since that was what first popped in my head and I just couldn't help my curiosity.

In mine if the...

SOrry, had not tried with a date value as I have had no need but do you happen to have an index on that column and not the other (could...

Look at ExamCram and ExamPrep books also. Those are clear in their order and I have had no issues with them. However, most folks used the Trancenders in the past...

IIS on the slower machine since in truth IIS will have the smallest workload unless you have some major server side script in mind.

Also, I doubt you will require all...

I still haven't totally figured out the difference yet and the optimal way to work it. But it does seem to evaluate faster which I think has to do with...

Use COUNT(*) will give you a row count, adding author will give based on related author in grouping. Can you give us an example of what you have to start...

Take a look here and specifically try DBCC CHECKDB to see what it reports http://dbforums.com/arch/68/2003/2/662838 but it commonly boils down to replication but may require a ticket with MS to...

Try this

AND (CASE WHEN ErrorID >= @ErrNumStart OR @ErrNumStart Is Null THEN 1 ELSE 0 END) = 1

I am just curious what effect it has. Is the code in an...

Ah-ha. Use it all the time. However it isn't a simple look and understand process.

Also, the is an undocumented -1 option in the type place as well.

Don't think it will...

Please do not crosspost. See additional comments in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12301&FORUM_ID=8&CAT_ID=1&Topic_Title=Mutually+dependent+foreign+key+constraints&Forum_Title=T%2DSQL

Please do not crosspost. However additional responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12299&FORUM_ID=65&CAT_ID=1&Topic_Title=Mutually+dependent+foreign+constraints&Forum_Title=Performance+Tuning

as for what the other post did the point is if someone has enough rights they can disable the constraint with the...

quote:

---

Have you checked Regional Options on the server. I seem to remember having this problem before and always struggled with it. I...

Fibers (AKA Lightweight pooling) have been around for a while. I know all the way to Windows 3.51 SP3, but I am not sure when SQL started using except I...

If you need just temporarily try a trial of LogExplorer. It is good for 30 days and may meet your needs in that timeframe.

If you are going to set @val = to say

SET @val = '1,2,3'

then you might consider an SP to strip the values to either a temp table or table data...