Why perform the shrink database if you've truncated the tables and are planning to load ?

build your load-data sorted on the tables clustered index and then load.

you could also put...

1.5 ct

maybe you could try to drop/create the proc with QA at your server ?

This could solve dependant settings (that are stored with the sp)

Edited by - alzdba on 12/16/2003...

- Log Simple does mean it only keeps the log-data until commit is done.

- Maybe index b.recstatus and force the use with hint.

- To keep log-chunks low you could make...

- If you can avoid lock-escalation, do so.

So set a table lock when you start loading.

- You can have autgrowth active, but if you detect space may be allocated during...

correct.

Should be :

CREATE VIEW v_selectarticle

AS

SELECT TOP 100 PERCENT article_id, headline FROM ARTICLES

ORDER BY article_id desc

This is a long shot, but maybe you could download a trial copy of erwin(CA) or another dbcompare-tool, reverse engineer your scripted db and compare it to a reverse engineered...

If you no longer want the jobownership-burden to be able to start a job, create an alert which you let start the job. So when you want to start your...

IMO this is not supported for sqlserver.

(unlike DB2)

What you could do is alter the clusterd index of those partitioned-view-parts to 100% fill and rebuild it. Keep in mind to put...

I think I've read this in a server-migration descussion/whitepaper.

There is a update sysjobs script which puts the new servername in the "originatingserver"column.

If I'm correct all it took was just a...

FYI: The replies counter in forums is not correct. It goes from 0 to 2.

Is there a way to Unsubscribe from a topic notification ?

maybe this helps :

select o.name

, c.text

FROM dbo.sysobjects O

inner join dbo.syscomments C

on O.id = C.id

and O.xtype = 'V'

where C.text like '%CREATE VIEW %'

when opening a page I already start scrolling down before it is complete.

When it completes, it scrolls to top.

Can you avoid that?

just my 2ct

Could you elaborate why your update statement would not qualify to be done using this view ?

If the update works, I presume you'll still find these data through...

- do you all have 56" screens ?

Where 's the time we had automatic wrapping ? I don't like to be scrolling horizontal.

- I also get some...

hanslindgren:

quote:

--------------------------------------------------------------------------------

Oki, in your opinion, what is application needs? Are they never relying on queries?

--------------------------------------------------------------------------------

Of Course it's ALL about queries ! But it's a tradeoff as to which one(s) will be...