That does make sense and the Query plans confirm it also.

You could try setting maxdop to 1 and try them both again. If your theory is correct then the...

Michael Valentine Jones (3/12/2008)

---

If the number of unique combinations of values is not large, you might start by creating an intermediate table with the rowcount for each unique combination of...

The insidious evil of character-based dates is thus exposed.

Ghanta:

what is the data type and range of the response columns?

SQLServerLifer (3/12/2008)

---

Mark has the best solution with sp_spaceused. Just beware if your database has multiple schemas. It will return schema-less results. For example

exec sp_spaceused 'dbo.summarydata'

exec sp_spaceused 'test.summarydata'

returns the following...

Actually mine was from Month Python. :laugh:

You need a recursive query, but they make my brain hurt, so I'll have to get back to you after dinner (unless someone else does it first 🙂 )

jamiejulius (3/12/2008)

---

The following query takes forever:

select top 1 Name from People where Status = 0

However, if I do this:

select top 1 PersonID from People where Status = 0

It comes back...

Can you post the query plans?

dileep_ratnayake (3/5/2008)

---

I cannot open the access file which has passwords through jet 4.0 it works fine when jet is used(so i think) but slows down when the driver is defined...

And if you want to "Create As" like this...

I think that Scenario is definitely preferred, and the canonical way to do it as well. The additional overhead seems minimal to me.

Thanks!

You have to remove it from replication.

Adam Bean (3/10/2008)

---

Ok, I'm creating a couple custom proc's (one for 2000, one for 2005+), and I'm trying to figure out once and for all, how SQL determines the size...