Hi Jim,

There are 2 points to notice here

1. The time it takes to failover the...

This could be due to the Resource contention or Blocking happening on the server.

Select * from kind of queries need to be avoided as much as possible. Select only...

Create a SSIS package in Bids

In control flow area, drag and drop two Execute SQL tasks in parallel and configure them as

Execute SQL task1 --- sp_startjob 'JOBNAME1'

Execute SQL task2...

Gail is right. Follow her advice.

--

Best Regards,

SQLBuddy

Yes, you can do it.

Best regards

SQL Buddy.

CASE them out using a TSQL statement.

Thank You,

Best Regards,

SQLBuddy

First Question is

Are you able to run the...

Much simpler method would be to use Import\Export Wizard.

Rt Click on a DB --> Tasks ---> Export data --> Select all the tables and specify an output text\csv file.

...

Go to the cmd prompt --> type dtexecui and enter

In the GUI that open, select the package stored in the MSDB and then go to the Command Line tab (The...

You can't find the Sa password but you can change it as Gail mentioned. Follow that approach.

...

Or Could be a Instance on a Virtual Machine Vs Instance on a Physical Machine

...

Check these Links

http://www.informit.com/articles/article.aspx?p=169612&seqNum=2

http://www.informit.com/articles/article.aspx?p=169612&seqNum=4

http://www.informit.com/articles/article.aspx?p=599700&seqNum=5

http://www.informit.com/articles/article.aspx?p=170234

http://www.informit.com/articles/article.aspx?p=169612&seqNum=4

Thank You,

Best Regards,

SQLBuddy

Follow the Great advice from Grant. He is Right.

Performance monitor is a very powerful tool. It can always be used for real time monitoring. You can add the required...

Perfmon should be your starting point to see if you are having any resource bottlenecks and possible causes.

...

Remove the shrink step in the MP as the experts have already mentioned. That will cause a lot of external fragmention and slows down the performance.

...