CirquedeSQLeil (4/18/2010)

---

I have tried the query myself and have also witnessed the huge log growth. Isolated environment where the only thing running was the query and it caused the...

CirquedeSQLeil (4/18/2010)

---

I have tried the query myself and have also witnessed the huge log growth. Isolated environment where the only thing running was the query and it caused the...

Matt Miller (#4) (4/18/2010)

---

Simply because SQL Server will use disk and/or memory interchangeably as needed. When it runs into memory pressure, it will flush things to disk. In...

Jeff Moden (2/23/2010)

---

For those that add a triple cross-join... eh... wrong answer because behind the scenes, it will cause explosive growth of one of the log tables for big numbers...

Jeff Moden (4/17/2010)

---

As a side bar, if you use Master.sys.All_Columns instead of the "local" copy of sys.columns, then you can get 16 million rows out of a single Cross-Join with...

mec (4/15/2010)

---

I realised it was a non clustered index, I was just surprised that with only three records per page (row size is 2.3k) and a clustered index on the...

Try:

SELECT StartTime

FROM TicketTransaction

WHERE

convert(datetime,StartTime) <= '12:30 PM'

AND

convert(datetime,StartTime) >= '05:30 PM'

You should also consider permanently changing the datatype of this column to...

Paul White NZ (4/16/2010)

---

More than one interesting problem was highlighted by the original question in this thread. My particular interest has been the generalised problem of interval matching in SQL...

Paul White NZ (4/16/2010)

---

The posted results came from a simple count - though I ran other tests with other aggregates like MAX- just something to make sure every row was...

Could you possibly post the actual SQL used in your tests ?

You dont have to post a full repro script, but it would be interesting to see the actual queries...

OK, I obviously cannot stop thinking about this problem.

I just thought of another really simple and very fast solution.

Just write the update statement like this:

update a

set CountryCode = case when...

Using an SSIS package definitely seems like the best way to go.

The execution plan you posted is unfortunately not an actual plan created with the method described in the article....

I just thought of another even more efficient way of solving this problem.

The problem with both your hash-method and my range-method is that they use a fast method to...

Is this SQL 2000 or SQL 2005 ?

Please post the actual execution plan as either an .sqlpan file or an excel file.

See This article[/url] for a detailed desciption of how...

Paul White NZ (4/14/2010)

---

Your US IP address range is 6.0.0.0 to 7.57.75.31 when decoded.

This is not valid (in the source) since it spans a class A address, and the end...