I can't say that I'm using DTA a lot, but the DTA will always try to optimize indexes for the current workload. So different workload files can result in different...

John,

you can't deny permission for the sysadmin role. And since you can't create your own server role either, the only solution I ca think of is using a generic login...

John,

for xp_cmdshell you can grant the users execution permissions on the procedure.

About the jobs it's a bit more difficult. Viewing the status, starting and stopping of jobs can be...

What type of replication have you been using merge or transactional ?

Where is the distributor running? On the publisher, the subscriber or a third server ?

I find it a bit...

What do you mean by "database links"? Are you talking about linked servers?

Linked servers you can either view in EM or query using this

select * from sysservers

where isremote =1

Markus

Not sure how your jobs looks like, but in general if a job has multiple schedules and the job is still running from schedule1 while schedule2 kicks in, the second schedule...

The checkbox is gone, but you can add a column filter which excludes al SPID's below 50.

Markus

IN SSMS open the "Registered Servers" window. When you right click on database engine  and select "Previously registered servers" it will add all the servers you had registered in EM.

Markus

Pavan,

I don't think there is "a" list. The tasks you should do depend on your environment, the type and the size of databases, availability requirements and a lot of other...

Did you run update statistics after the upgrade?

After upgrading a database the old statistics become invalid and SQL Server can't use them anymore for optimizing the query plans.

Markus

Kostas,

I don't think it's the hot fix which causes this behaviour. On my test sytem I only applied SP2 no toher hotfixes.

While the trigger works fine for CREATE and...

Maria,

you ned to use the MOVE TO option to provide the path where you want to place the database files. See BOL for the details

Markus

Vika,

you don't say if the column you're querying contains jaust a single character or more.

In case it's just a single character you can use this:

SELECT * From table1

where ASCII(col1) between...

I agree with all comments above.

While in theory Raid1 might be faster for reads I never saw any documentation of such a case in real life. I even remember MS...

Adam,

with "SELECT SERVERPROPERTY('ComputerNamePhysicalNetbios') you can query on which clusternode SQL Server is running.

You could then create a job which is scheduled to run when SQL Agent starts. During failover...