if it's access....try -1 instead.

On SQL Server true=1 false=0

Access, true=-1, false=0

As I recall, table spools occur when temporary operations get to a point where the operation happening in mem is spooled to disk so that it doesn't continuously need to...

The only real difference I know of (that might fit within the "desktop-friendly" category) is that it's the only version not to require 512MB for SQL. It's about the...

Sergiy (12/2/2007)

---

In our country it's "I am NOT smarter than 10 years old".

But it still...

chandrika5 (12/3/2007)

---

Queries use tempdb for sorting/grouping etc. Please correct me if I am wrong here. I was in a similar situation. I bounced the engine(off hours) and set the tempdb...

This is more of a networking question than anything else.

That being said: if you are to dual-home your server, you need to assign an IP that is not...

Try this instead - no cross join. On my machine - 1M records inserted finish in 10 seconds.

declare @g datetime

select @g=getdate()

drop table randomFullname

drop table firstname

drop table lastName

drop table fullRandname

create...

If you were doing a big transaction, it could still cause the transaction log to grow. It doesn't log any less, it just truncates once the transaction commits.

PW (12/3/2007)

---

CREATE NONCLUSTERED INDEX [IX_TableX_ClientID] ON [dbo].[TableX]

([ClientID], [ColA], [ColB], [ColC])

INCLUDE ([ColD], [ColE])

Might there be a good reason that ColA, ColB, and ColC are part of the index columns...

Even if it IS unique, there may be some usefuleness in having an index with the PK and other columns in the key part of the index. The key...

TheSQLGuru (12/3/2007)

---

1) What possible need can there be for attempting to return 42M rows to the client?

2) Table scans are not necessarily a bad thing - especially in...

Mark - your error is coming from you not putting quotes in this statement:

if exists (select 1

from...

Where are you getting it? The only place I can think you'd be getting this would be line one, and that's only if you hadn't previously created the temporary...

California (12/2/2007)

---

I have some updates to share with you folks. Here are couple of things i have done to make the query run faster - but tough luck. Here are...

Comments:

- I don't know how big these temp tables are, but if they're anything more than a few records, you should at least consider indexing the temp tables,...