Putting spaces in between the /?

setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MNODE2\micro /SQLSYSADMINACCOUNTS=MNODE2\darshan /SAPWD=123

select * from sys.dm_exec_requests where blocking_session <> 0

That wont cause a deadlock, that will cause blocking.

You need to do things in a different order, eg 1 query update t1 then t2, other query update t2 then t1

CREATE...

Take a look at the definition of the views and you will see the differences.

One relates to reports, the other to items

Unless you have custom auditing in place you wont be able to find when it happened.

You could try the default trace but depending on how busy the server is will...

Such a big difference between the estimated and the actual, which is why you should always attach the actual plan as that is what SQL actually does not just what...

Actual execution plan?

What is the actual execution plan?

What is the definition of the Load9_PotentialOverlaps table?

Also why all the indexes on varbinary(8000) columns? The max length for an index key is 900...

I would go RDS if you want "Failover Clustering", while it is not true failover clustering, RDS allows the option for having the server in multiple AZ within a region...

I think I can get an understanding of the bits covered from the QA website

http://qa.com/training-courses/technical-it-training/microsoft/microsoft-sql-server/microsoft-sql-server-2008-and-r2/designing,-optimizing,-and-maintaining-a-database-administrative-solution-for-microsoft-sql-server-2008/

Couldn't find 50400 on the MS learning website any more, guess its due to the exams...

The main topics I keep getting low marks on the transcript are

Designing a SQL Server Instance and Database Solution

Designing a monitoring strategy

Then things on

High availability

Backups and Recovery

Would also be...

WWDMark (3/11/2013)

---

anthony.green (3/11/2013)

---

Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.

I do...

Nope not done 50400A, but did do 6231A and 6232A, which where when 2008 got released which covered the DBA and DD exam routes at the time.

I do have a...

You need the original LDF, the DB was detached read_only so it will not allow you to create a new LDF for that DB, you need the one it was...

Bring up the wizard for DBMail and then go in and use the the Manage database mail accounts and profiles, then select the option you need from the next...