SELECT * FROM master.sys.objects

EXCEPT

SELECT * FROM msdb.sys.objects

How big are the diffs and log (avg daily).

I was first thinking unreleased spacefrom ntext or image datatypes. But it is being released so that can't be it (dbcc cleantable would have solved that).

The only real question...

Can we see the table definitions plz?

Koen Verbeeck (3/2/2011)

---

One...

Duncan Pryde (3/2/2011)

---

Ninja's_RGR'us (3/1/2011)

---

What about the questions where it could be multiple choices and there's actually just 1 valid answer? Those are the harder questions we have here. ...

a unique primary key is like saying the white white rabbit. It's redundant and the code parser is likely picking this up.

However you ARE allowed to have 2 unique...

reported as spam...

Makes sense if the # of pages in the index increased a lot. Makes the seek much costlier where the key lookup wasn't that much of a big deal.

P.S....

Sounds a lot like homework to me. What have you tried, what do you think and where are having having troubles validating your assumptions?

David Benoit (3/1/2011)

---

Agreed. I would have chosen more than one but since it didn't say that I chose only the...

SKYBVI (3/1/2011)

---

ChazMan (3/1/2011)

---

I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

Also, in my opinion,...

It's always going to be a best guess.

One way I use to trace this is look at the full backup size (daily in my case). That shows you the...

Good idea... I'll try that sometimes.

Michael Valentine Jones (2/24/2011)

---

I have to disagree; the absolute value of Pi is Pi.

Absolute value,

From...