Viewing 15 posts - 11,221 through 11,235 (of 13,469 total)
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...
April 18, 2009 at 7:40 pm
yulichka (4/18/2009)
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...
April 18, 2009 at 7:01 am
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.
April 17, 2009 at 11:49 am
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,...
April 17, 2009 at 11:22 am
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...
April 17, 2009 at 7:29 am
homebrew01 (4/17/2009)
Would the default trace have that information ?
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...
April 17, 2009 at 6:45 am
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...
April 16, 2009 at 10:40 am
it's simply
ALTER DATABASE Yourdbname SET RECOVERY SIMPLE
or
ALTER DATABASE Yourdbname SET RECOVERY FULL
April 16, 2009 at 10:29 am
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...
April 16, 2009 at 6:25 am
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...
April 16, 2009 at 5:06 am
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
...
April 15, 2009 at 10:08 pm
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....
April 15, 2009 at 11:03 am
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...
April 15, 2009 at 10:15 am
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'
...
April 15, 2009 at 10:12 am
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...
April 15, 2009 at 8:25 am
Viewing 15 posts - 11,221 through 11,235 (of 13,469 total)