Are you using Snapshot isolation level?

Are you doing online index rebuilds?

julia.nicholas (4/4/2008)

---

Of course, duh! I didn't think of that. So basically as long as when changes are made on the Principal server in terms of adding new jobs and...

Could you explain more what you want please?

What are you trying to see?

Just bear in mind that the 'encryption' of views/stored procs is not unbreakable.

Took me under 5 min last time.

Which statement?

Applying tran logs in a log shipping scenario? Disaster recovery?

julia.nicholas (4/3/2008)

---

True, but you...

1) It's old syntax (I think it's deprecated) with the same behaviour as Simple recovery mode.

2) Lazy writer writes dirty pages to disk based on memory pressure. Checkpoint runs from...

Take a backup and restore it as a new DB.

I assume you want to speed them up. Correct?

Is there blocking?

Is the query written optimally?

Are the indexes useful (ie, is the query using indexes).

Run the query with the execution...

See if there's blocking which is causieng the query to run slower than usual

Have a look at the query itself, see if it can be optimised.

Run it with exec plan,...

What's the initial size for TempDB and what size is it reaching?

32 bit or 64 bit?

Run this, and see what the cache sizes are.

SELECT name, SUM(single_pages_kb + multi_pages_kb)/1024 AS SizeInKB

FROM sys.dm_os_memory_clerks

GROUP BY name

In...

What is it doing and what should it be doing?

Some schema definitions, sample data and expected output would be useful.

What are you struggling with?

Does this do what you want?

CREATE TRIGGER trgCopyNewUsers

ON Users -- Table the trigger's on

FOR INSERT -- What operation it triggers on

AS

Insert into Table2 (UID)

SELECT UID

FROM...

It's a gui app that lets you select the server and package, set the options and parameters...