I have a lot to do so I can't come up with a bullet list.

Keep the Staging and DW database separate. The main reason from my perspective is it allows...

speedcat (9/7/2016)

---

Hey, I'd be interested in seeing the results of your audit, if you can paste it here somehow. Even if you have to summarize, or redact anything sensitive.

I'm...

What do you mean play with the schema?

Actually that Server is 2012 but that is still supported.

Thanks.

If I change the compatibility level from 2005 to 2008 and we experience issues chaning baco to 2005 is an option.

GilaMonster (8/11/2016)

---

Because spacial indexes work by creating hidden tables. CheckDB picks up the hidden table name, but you can't directly affect that table.

And did you recreate the index? If so,...

GilaMonster (8/11/2016)

---

Welsh Corgi (8/11/2016)

---

I run the following command in a test environment which contains the same index and I do not get any errors:

DBCC CHECKDB(PrismData)

WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS,...

It is not a view. It is a table.

Yes...

I dropped and created it in the test environment for now.

Thanks. 🙂

I cheated and went into SSMS and I found the name to be different so I executed the following and it worked:

DROP INDEX [SpatialIndex-20160728-162910] ON Postal;

I'm not sure why...

I executed the following Statement to identify the extended index:

SELECT

OBJECT_NAME(PARENT_OBJECT_ID) AS table_object,

name,

create_date

FROM sys.internal_tables it

WHERE INTERNAL_TYPE = 207

AND...

Gail,

I know that you no more than just about anyone.

I ask him to fix it but he declined.

GilaMonster (8/11/2016)

---

Welsh Corgi (8/11/2016)

---

That is what I wanted to...

I run the following command in a test environment which contains the same index and I do not get any errors:

DBCC CHECKDB(PrismData)

WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS

Hmm.

That is what I wanted to do but I...