One more important detail. The SAME page can be read multiple times in that total. So even if the whole table has only 5 pages, the total reads...

Of course, I was just having fun with the tempdb thingie.

Yes, but only when running the code in tempdb, that's why I was having a little fun with it in the code snippe with a bunch of usings.

Tx, I used...

Craig Farrell (11/2/2010)

---

Hmmmm....

CREATE TABLE...

That version works. Not using PK but same effect.

CREATE TABLE #Table1

(

TeacherID BIGINT

, StudentID BIGINT

)

CREATE UNIQUE CLUSTERED INDEX #IX_Tbl1 on #Table1 (TeacherID, StudentID)

CREATE TABLE #Table2

(

TeacherID BIGINT

,StudentID BIGINT

) ON...

Even if it makes no difference here, it should read : IF Object_id('tempdb..#tmp') IS NOT NULL

With tempdb.. missing you'll never have a hit on that id.

Craig Farrell (11/2/2010)

---

Yeah, even this doesn't work:

CREATE TABLE #tmp (tID INT);

IF Object_id('#tmp') IS NOT NULL

BEGIN

DROP TABLE #tmp

END;

IF Object_id('#tmp') IS NULL

BEGIN

CREATE TABLE #tmp(tID INT, tTxt VARCHAR(50))

END;

So, I'm going to go with...

I do that in prod no problem. Can you post the create table and index scripts you are using?

Craig Farrell (11/1/2010)

---

Of course to make my life interesting, this gets grumpy too and I can't remember how to get it to behave offhand. Maybe someone else remembers how...

Jeff Moden (11/1/2010)

---

Craig Farrell (11/1/2010)

---

Of course to make my life interesting, this gets grumpy too and I can't remember how to get it to behave offhand. Maybe someone else...

Grant Fritchey (11/2/2010)

---

Yep, what he said. Generally the size of the data stored will define, in pretty close approximation, the size of the database. You can get the size a...

I wish I knew the problem but I've never seen that one.

Hopefully someone else will jump in and figure this one out with you.

Y

Would have been much better, 50% space saved in the DB, and then remove the signature and you're off to the races! :w00t:

GilaMonster (11/1/2010)

---

Bear in mind that you won't find...