Mark, first of all the comment that you've made about India is completely uncalled for, and out of context.

Second of all, it is very funny that YOU are making that...

Steve, you could simplify your WHERE clause with something like this:

WHERE m.entrydate >= CAST(CONVERT(char, CURRENT_TIMESTAMP, 112) AS datetime)

AND m.entrydate < CAST(CONVERT(char, CURRENT_TIMESTAMP, 112) AS datetime)+1

This is more efficient, if...

While you bring up some interesting points, a not-so-experienced DBA might be quick to implement these suggestions, without reading the 'conclusion' section.

Eventually this type of techniques end up doing more...

quote:

---

So for all those out there who randomly use lower case and upper case and argue that the code works just fine...

It is a worst practice when it comes to production class code.

But it sure is a power users tool and a shortcut for ad hoc queries. When I am...

Steve, just wanted to highlight some issues with this article:

SET ANSI_WARNINGS has nothing to do with "Divide by zero" errors. So, it will never suppress that error by returning a...

SQL Server 2000 Resource Kit CD is indeed included in MSDN subscription.

HTH,

Vyas

http://vyaskn.tripod.com/

Please do post or update the article, if there's a scenario that benefits from reusing of IDs and yet keep track of info related to things done by old owners...

Hmm...I wouldn't reuse those IDs, as it will become impossible to track which SJones has created what, at a later date 🙂 There could be a better example, though I...

This syntax is covered by ANSI standard, but is not implemented by SQL Server yet. Use EXISTS instead. Here's an example:

CREATE TABLE t1 (i int, j int)

CREATE TABLE t2 (i...

SET is preferable, because it is ANSI complient (so was I told by an experienced MVP, I didn't look up the ANSI spec myself).

With SELECT you can assign values to...

Looks like you dealt with fairly smaller databases. The same scenario could have been worse, if the databases are of size, say 10 GB (in terms of restore times). Logshipping...