To avoid adding more re: date accuracy, please refer to the following, and currently active, thread around getdate() accuracy:

http://www.sqlservercentral.com/Forums/Topic500971-338-1.aspx

Greg Jennings (5/16/2008)

---

JohnG,

Just for clarification, are you saying that a date/time value 1 millisecond before midnight and a date/time value 1 millisecond after midnight would have the same value in...

SQLZ (5/15/2008)

---

As you've noticed SQL Server datetime types include the time as well. So you'll have to take this into account. Try this:

select count(datetime) from XYZ where datetime...

That's a real bad limitation! Thanks...

I'm seeing a lot of this lately. I.e., statements such as:

;WITH ...

Note that the semicolon is NOT part of the...

I can probably see using CLR for some specialized functions, but probably NOT for performing DML operations on tables. Just because there is new way of doing things, it...

Along the same lines, you may need a "rethrow error" procedure like the following or you can put the "rethrow" logic into the previously suggested procedure.

SET ANSI_NULLS ON;

SET QUOTED_IDENTIFIER ON;

GO

ALTER...

Its suprising to hear that you use Full-Text indexing but have not been administering it and have no commitment to administer it (which is what I was talking about).

...

Interesting comment. We're running a SaaS business using it to index plain text as well as binary documents (Word, PowerPoint, PDF, etc.) with...

But the database im development will insert arround of 10.000 new rows per day.

I don't have knowledgements of full-text indexing, but we can't refill every day the Full Text Catalog...

My strong recommendation is to use full-text (CONTAINS) vs. LIKE clause pattern matching for tons of reasons:

1. Performance!

2. You won't get false positives. E.g., "%good%" will also find "goodness",...

The downsides of TRY...CATCH are:

1. You cannot re-raise the original exception after examining/handling it in the CATCH block. Contrast with Oracle's PL/SQL exception handling where you can re-raise the...

I disagree to a bit. It...

As always, a great article from Jeff.

As for performance testing of various techniques by anyone, I am continually amazed as to the incorrect methods for generating sample data.

Example (taken from...

I feel your pain as I've also come across a very similar situation (i.e., the order of events couldn't be...