SQL will use the index if it deems it helpfull. In other words, "no action required"

Add 1 month to the start date, and subtract 1 day. 🙂

Resender (10/31/2012)

---

Jason Selburg (10/31/2012)

---

Luis Cazares (10/31/2012)

---

It's hard to be sure about what you need to do, but as I uderstood, you have a Sites table that is referenced by the...

Luis Cazares (10/31/2012)

---

It's hard to be sure about what you need to do, but as I uderstood, you have a Sites table that is referenced by the OrderHeader table.

I'm thinking...

The MERGE command is available in 2008 and beyond.

Without getting deep into your question, would the MERGE statement be of any help.....?

Here's a "poor man's source control" I wrote/found/modified a few years back. (In all honesty, I can't recall how much of this was "found" on the internet and how much...

What exactly are you trying to accomplish? Delete any workstation ID's that dont exist in your table?

If so ....

DELETE FROM W

FROM tbl_Workstations AS W

LEFT JOIN...

I'm in agreement with you. Another way to think of it is, why would you put a table of contents in a 1 page "book"?

Sql Server will ultimately pull the...

aditya.anita.moitra (10/12/2012)

---

Jason,

I am in the same situation to implement Data Driven Subscription to a File Share while we are using SQL Server 2008 R2 Standard Edition. I'm really interested in...

That's pretty odd Jeff. One would think that "gem of sql code" would be at the top of the list.

brendan woulfe (10/3/2012)

---

You got to be kidding me. It does exist. And it's even called Best of SSC. :hehe:

Apparently my google skills have failed me. Thanks Jason....

Try searching this sight for "Best of SQLServerCentral" and only show articles.

http://www.sqlservercentral.com/search/?q=Best+of+SQLServerCentral&t=a

+1

Just a possibility, but read up on "parameter sniffing".

Also, I've found that CTE's are generally poor performers when dealing with large result sets. In those situations, I'd suggest using temp...