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...

it's simply

ALTER DATABASE Yourdbname SET RECOVERY SIMPLE

or

ALTER DATABASE Yourdbname SET RECOVERY FULL

glad you found it Dom;

this site has a Ton of really useful scripts. enjoy.

i cleaned up my original post, since the update to the CODE window made HTML font info...

yes and no.

you can create a table with the a primary key and the list of possible values.

then in the main table, you store the key from that table as...

i did it the same way as Phil, just too slow to post.... i compared the value to the floor of itself:

select

mynum,

case

...

good point; i have a handfull of big functions that cross the 4000 char limit, i wonder just where exactly they split in the code....

definition of the view?

the more info you give us, the more we can help.

what did you try so far? does the base table have a column with an updatedtime in...

this finds any object that references a specific string...just limit it to procedures int he where statement:

DECLARE @PhraseToFind varchar(250)

SET @PhraseToFind='syscolumns'

select obj.name,obj.xtype,

case obj.xtype

when 'TR' then 'Trigger'

when 'P' then 'Procedure'

...

also, depending on the business model, you might not want to DELETE rows that contain a reference to some parent record, but simply set the value to NULL in the...