for others reading brd's issue, we kind of kicked around searching via CHARINDEX on the same issue here:

needing to develop a sql search for all words,...

obviously, that would cost a...

they don't really get executed first or second.... it's more like ALL constraints, including whether a column is nullable or not, all get evaluated prior to the the insert or...

hmmm... thinking about it, i think you have to test the count > 1 and EXCLUDE those indexes istead;

a table with no rows simply will not return results in the...

Marios Philippopoulos (4/20/2009)

---

I need a script that will list all indexes in a database that SHOULD be defined as UNIQUE (based on the data distribution) but are not.

Does anyone have...

well the db will not get smaller... a db stays at a certain size in order to save space for future work...but the space used/space free will change.

run sp_spaceused on...

you cannot do this.

a query with a group by does not expose data so it can be updated.

you must...

i read up on RamSAN thanks to you guys;

I'm jealous, quite frankly.

seems to be faster than a bat outta...well

but it's not a cheap solution either. that's some big money to...

does truncating force a rebuild(resetting?) on statistics if auto-update statistics is ON?

i know there is a threshold of 20% rows changed before the auto update occurs, but since truncate...

your confusing presentation layer with the data layer.

you could argue that all your data be stored as a bitmap/image, since that is how it is going to be presented.....hopefully it's...

yulichka (4/18/2009)

---

There is note under script:

Note:

Use the CatalogCleanup.vbs script when your Commerce site is not running to prevent performance impact and to make sure that all temporary tables are...

yes you need to delete temporary tables.

MS recommends at least every week.

you can use the script provided and never bring your database offline.

i would use the script that Austin_123 pointed you to, straight from Microsoft;

one of the nice things it says is that if you DON'T take the catalog off line,...

you are right in your suspicions, it's gotta be dynamic.

the reason is any sql statement cannot take a variable for an Object.

so whatever the object, whether databasename or tablename, if...

no, unfortunately.

the default trace tracks DDL stuff...who created /altered/deleted database objects...it doesn't have anything related to DATA changes. you need a separate...

i think the rule is a count of 20% of the total rows in a given table have to insert/change before auto-update of the statistics occurs. On a billion row...