I probably would play around with it. During one layoff period I built a soduku solver. I'm disappointed in performance, (two minutes to find the same three results I had...

I'm not sure I understand how the query optimizer can fix up a poor performing query just by letting it figure out the problem and fixing it. I've never seen...

Richard Campbell says "The only reason I am hodling back on this is that it would involve ferreting around in a lot of queries that I didn't write and changing...

Gail says "If you have a composite index (index defined on multiple key columns), the key columns are present at all levels of the index, leaf and non-leaf. Any include...

Richard Campbell says "...TagID(Int)...SampleDateTime(BigInt)...but I am almost convinced the the clustered index should be reversed because SampleDataTime has much greater uniqueness, always increases (obviously) and we ALWAYS specify a DateTime...

What? NOBODY mentions the major reason why identity fields were frowned on? Has this reason disappeared? Each insert is going to the same page, at least until the page is...

Thanks for the documentation. I supposedly have version 3.5. I haven't figured out how and where to put /doc:filename in Visual Studio. It appears to be a command line option....

"...The XML Documentation facility built into all the .NET languages..." - I wish! VB.NET supports intellisense so the hovering images of what something does will be supported if you are...

As always, this site is a good place to look for answers.  A group I have been working with asked the same question.  Can SQL Server 2000 run a DB completely...

This is a nitpick, but that produces a record set, not a dataset

Actually use "ID>0" in the case statement, then you just have to modify the where clause

That is interesting behavior, especially when COALESCE works.  Note that if you change the constant in the view to a case statement, the isnull join works as expected.

View vw AS...

1. Everyone has limitations, hand me a crystal report and the logic used to create the report and I can figure out how you can get from A to B. ...