Whatever you do, don't lie to them. If you get asked a question on an area you're not familiar with, tell them that you're not that familiar with it. If...

Good to know. Thanks for that.

I tested with brackets or with quotes, not with both.

Robert Brown (12/20/2007)

---

We have two identical copies of the database on the same server (confirmed with SQL Compare) and are using SQL Server Query Notifications to cache data in the...

SELECT Data_ID, DateTime, Batt_Vltg

FROM

tableName

WHERE

DateTime = DATEADD(hh,4,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

Doing conversions to Varchar to trim the time off a date is inefficient and CPU intensive.

To add to that

IO contention from different file placement

Network settings (full/half duplex, auto vs specified speed)

CPU contention with other apps running on the server (if any)

Have you checked what's running...

Can you use a DTS package? iirc, the Excel source allows skipping of rows.

Could you perhaps delete this thread please, as it's in completely the wrong forum.

There's no need to post in multiple forums, the regulars read all the forums

Thread continued here

Why is the group by there at all? You aren't doing any form of aggregation that could require a group by.

If you're trying to eliminate duplicate rows, rather use Distinct.

Well, that depends on whether its the name that's duplicated, or the name...

Jeff Moden (12/19/2007)

---

I didn't know how long it originally took and, like the bumble bee who doesn't know it's not supposed to be able to fly, I rewrote it... it...

Jeff Moden (12/19/2007)

---

BUT... take a look at the execution times and the CPU usage... the Index Seek is twice as slow as the Index Scan in this case (3 times...

Not sure. I'll have to check. (Tomorrow. Is bed time here. I shouldn't post this late at night)

Since the like determines that the first character is between 0 and 9,...

You don't need the temp table. (unless you're using it for performance reasons)

WITH ALevel (ConsultantID, AchieveLevel, AchieveTitle, PeriodEnddate) AS

(

SELECT ConsultantID, max(AchieveLevel), AchieveTitle, PeriodEndDate AS DirectReports

FROM Volume

WHERE ConsultantID = @ConsultantID

GROUP BY...

Edited for correctness.

And if there's an index on government_id, the like might allow the optimiser to use it for a partial scan, the len (since it's a function on...

You don't. But one's time is, unfortunately limited, and a more productive use of one's time may be to fix the things that are known to be broke, before investigating...