It actually is a question every mature dba must pose !

- Just to put people back with their feet on the ground.

- to determine if performance may be...

What about sequenced shifts .. should the emp clock out and back in ?

I have elaborated a bit on Dave Ballantynes provided script.

declare @sched table ( EmployeeId int not null,...

How does this system handle night shifts ?

EMP-1 7-10-2009 22:00 ...

- did you grant the needed auth for your service account on the windows folders at the new drive ?

- did you follow the procedure as explained in BOL ?

-...

You need to provide access authority to the new file location(s) to your sqlserver instance service account !

For startup parameters of SQLServer, check out Books Online topic "Starting and Restarting...

Prepare your operation by determining which objects you want in which filegroup.

Just a couple of helping scripts:

http://www.sqlservercentral.com/articles/Administration/64275/

http://www.sqlservercentral.com/scripts/Miscellaneous/31541/

Another forum Q handling about the same subject:

http://www.sqlservercentral.com/Forums/Topic797121-1291-1.aspx

Give me a moment to whipe out a teardrop of nostalgia :alien:

just a couple of helping scripts:

http://www.sqlservercentral.com/articles/Administration/64275/

http://www.sqlservercentral.com/scripts/Miscellaneous/31541/

Maybe this can get you started :

select h.server as Server

, name as Job_Name

, description

, h.run_date as Run_Date

, h.run_time as Run_Time

, h.Run_Status as Run_Status

, h.message

from msdb..sysjobs s

left join

...

These topic options were described when SSC switched/upgraded the forum software back in the days. 😉

On the other hand, if you want to print or copy the full topic at...

Fred Zimmerman (10/1/2009)

---

Seemingly great answer but leaves me ?s.

1) What do you set your Recovery to on your databases backed up.

2) Aside from stated Diff backups you do, do you...

So, for a "classic" tally table ( i.e. start with 1 increment by 1 ), Pauls solution performs best.

If you actually want a dynamic tally table ( i.e. start...

Indeed strange findings.

I think the best way to tackle this problem is to use sqlprofiler to capture the load launched on both engines (FULL).

Especially check the connections settings to actually...

My guess your alias references are resulting to these strange findings !

Did you try using aliasses for both objects

DECLARE @helperStr8000 AS VARCHAR(8000)

SET @helperStr8000='bcp "SELECT * FROM dbname..tablename x

WHERE EXISTS...

if you use "dirty reads" you allow your applications to use uncommitted data !

No complains are accepted for that ! :unsure:

Cursors can cause the need to be materialized in...