Thank you for your response.

At this point, after continuing my investigations, it does appears that the command to Update Statistics has recently been added, and will now be removed.

Cheers...

Hi,

In an ideal situation, that's what I'd do. As you might be inclined to guess, this is pretty far from an ideal situation.

This isn't an in house database system....

A very worth while read, but I'm not sure if I agree with the conclusion that STATIC is always faster than FAST_FORWARD. The table fitting in cache and point...

Extremely poor. I had ticked the second one and got it wrong when it's clearly right, as demonstrated in this thread.

Consistency. 100%. You'll need high quality code to bridge the massive gaps that will develop in time if everyone is working independently.

So saying, I'd love to hear, from...

I agree with all the other protestors.

1000^8=1024^8

Sorry, that dog won't hunt.

Secondly, where is the unit of measure? What is this a measure of, baby's breath and ether?

Thirdly, the "describing...

Let me be the first to say

GO SOX!!!

😀

I worked writing scripts for both these database platforms (and Sybase, and Postgres...) for years.  I lost most of my hair designing procedure based applications where the backend could be MSSQL 6.5 or Oracle 7.3.  Over the...

Wow.  Tested it out and got the same results on mine.  Will definitely bear that one in mind.

Thanks Mike!

Cheers for that Mike.  I'm coming from an Oracle background and in older editions OUTER JOIN=Full Table Scan.

I spent a bit more time looking into EXISTS after my post, and...

Sorry, let me rephrase the question:

Can anyone explain, in detail, why the outer join solution is faster than the Subquery solution in this example?  Is the Exists method fastest...

Can anyone explain, in detail, why the outer join solution is faster than the Subquery solution in this example?  Is the Exists method fastest of all?

Hi,

I didn't read the whole article, but had a couple on the more basic points.

SELECT

COUNT(*)

FROM

[MY_EVENTS]

WHERE

---CASES 3, 4 AND 5

(([STARTING_TIME] > 7/1/2007 12:00 PM AND [STARTING_TIME] < 7/1/2007 1:00 PM)

OR ([ENDING_TIME]...

I'm originally from Boston, but have worked in London for my entire career.  In my company we come in between 8 and 10 and leave after about 7 and half hours.  For me,...

I got this one wrong as well.  I'm hoping for an explanation for when, if ever, the index create memory setting would be changed.

Cheers,

Dave