.

Please see the attached.

I think I have got the idea on how the whole assigning process flows. Now come my following questions:

1. When will the employee put in request? do they all put...

I would like to know

(1) how do the employee put their request in? a sheet that they sign up and somebody will then type those data off the sheet? or...

Try to type 'sqlwb' ( for SQL 2005), or 'ssms' (for SQL2008) in Start-->Run on the server where you think it's missing. and see what happens.

The command 'net statistics server' seems not so reliable to report the uptime of a server.

Out of curiousity, I ran it on on several servers, the results:

(1) my...

Right Click TempDB in SMMS, click Properties-->>Files, and see what is the initial Size for tempdev file. If it is 100GB( 102400 MB) or any number you dont like, change...

Or....the same set of tables in 60GB db have much more rows than those in your 40GB db?

How about setting that node you want to failback as the PREFERRED OWNER for your SQL service?

Then whenever that node is available, SQL will failback to there.

pankaj.baluni (1/5/2010)

---

Hello,

I have a scenario, let's take an example log shipping is suppose to happned for log1, log2, log3, log4, log5, log6 and log7.

now, untill log1, log2 and log3 everything...

This article may give you a clue.

what is the auto grow rate? maybe it is too small to accomodate the data writings so it has to auto grow very often?

Maybe you could assign a much...

Thanks for sharing.

Just wanna add one note about the code for

changing the Maintenance plan ownership :

use msdb;

go

update dbo.sysssispackages

set ownersid = (

select sid from msdb.sys.syslogins where name =...

In my opinion, Development DBA is like Architect, but would do more detailed design, test, and review codes from Developers (if there is any), if there is no developers, Development...

This is really interesting, guys. I feel i have to report back.

I reran the job just now with my trace turned on(hoping to catch the ALTER) , and it...