Unnecessary. The # designates it as a temp table, temp tables are always in...

Yup. Assuming there's only one foreign key that is.

I suspect that's there to 'prevent' someone from copying the entire scripts collection, sticking it on a DVD and selling it, or collecting the articles into an ebook and selling...

Ok... Take a read through this when you get a chance, and if you have questions please ask: http://www.sqlservercentral.com/stairway/73776/ (Yes, I know it's long)

Also, if your backups start to grow...

Depends. Is anything changing the value of MAX(sectionnumber) in dbo.BNYWorkingSecTable?

lawson2305 (5/28/2014)

---

ok sorry for my misunderstanding but I thought that is why you do Log backups to commit the data to the DB and clear the transaction data from the...

Backups don't commit transactions, so not sure what you want there.

I don't know what was done when the DB ran out of space, so can't comment on whether it's strange...

If it's Microsoft's CRM (the vendor is Microsoft), then making any schema changes is a violation of the support agreements afaik, will probably result in you losing any support from...

lawson2305 (5/27/2014)

---

Now if I got in Shrink by file I get some strange data saying currently allocated space of 1300 MB and 82.81 MB free.

Ok if I go into Shrink...

Can you run DBCC UpdateUsage and then check free space again?

If you have exact duplicate indexes, it doesn't matter which you drop, they're identical.

It's you. That link works find for me.

And you're considering dropping one that is being used, as shown...

Because it doesn't always show the correct values. Specifically it will...

Why?