Stefan Krzywicki (12/6/2010)

---

I have a job that is now approaching 20 steps. If I were to place each functionally grouped set of steps in its own job, I would have...

Anyone want to help an OP understand a Celko query?

(I did a ROFLMAO when I read the OPs handle. Seems to fit when talking 'bout Joe!)

Craig Farrell (12/6/2010)

---

It works just fine. Apologies, very nice solution. I'll be --------------> way for...

Jeff Moden (12/6/2010)

---

Kit G (12/6/2010)

---

Ah ha! I knew it! Google is run by...

And for all the others you may need, check out the common date/time routines link in my signature.

ken.trock (12/6/2010)

---

Hello. I pull data from a SQL 2000 environment via SSIS into a 2008 DB of ours.

Select Distinct RCD.Variable4

FROM Route_Call_Detail RCD

WHERE RCD.[DateTime] > '12/4/10' AND RCD.[DateTime]...

First, can you verify that this is NOT a homework / test / interview question?

Instead of doing this through a trigger, have you tried a filtered indexed view with either...

GilaMonster (12/5/2010)

---

However note that the first 'fact' stated in that article is incorrect. Changes to table variables are logged. They don't participate in...

:Heavy sigh:

:Bang head on desk:

Just spent 3 hours investigating a "discrepancy" in two reports that should match up. Has to be fixed before Monday. Finally figured out that they were...

"It depends". 😀

IF...

If it's a named instance, you may need to connect by ServerName\InstanceName

Well, the execution plan that you sent is just doing a "SELECT * FROM TestData". This results in a simple table scan of the TestData table. Which only tells me...

Like this?

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made...

I don't see anything wrong with this query.

Questions:

1. What does the actual execution plan show?

2. How many records are in this table?

3. What indexes do you have on this table,...

I think you also need to consider the expense of maintaining all of those indexes. Every insert/delete will have multiple indexes to update. Updates can affect multiple also.

I think a...