I would start with this blog [/url]post by Paul Randal.

Please read the article in my signature about posting these types of questions. After you have supplied the table definitions and sample data please provide the code that you currently...

Nope. Mirroring is a single Principal and a single Mirror. Other options would be replication, log shipping, SAN tools (replication, etc).

This is from BOL:

Important note Important

Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services,...

I would start with this guide[/url] from Brent Ozar and it should have most everything you need.

Try adding "WITH" prior to (NOLOCK) i.e. WITH (NOLOCK)

You could periodically shrink the database, but I would run a reindex operation after...

You compare Funded_date to the following:

- Greater than or equal to - DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-5, 0) = 2014-01-01

- Less than - DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, 0) = 2014-06-01

-...

Have you tired to reinstall SSMS? If not, you might want to try that.

The other question I have is why are you using "Edit Top 200 Rows"? Why not use...

Adding more TempDB files will help with SGAM and PFS page contention. I would start with this post[/url] to make sure that you are not seeing contention during the operation....

dndaughtery (5/8/2014)

---

I would think that the best practice would be to create an enviroment variable on each machine (Dev, QA, UAT, and Prod) and set all connection Mgrs to use...

ASYNC_NETWORK_IO usually doesn't mean that you are waiting on the network. It usually means that the application is processing the data one row at a time or simply doesn't acknowledge...

Take a look at this thread and see if it helps: http://www.sqlservercentral.com/Forums/Topic604406-146-1.aspx

1. Can you update the spoom sproc to accept a Customer parameter and just pass it into the stored proc and have it do the filtering?

2. If not, you could...

For BI related stuff there is the Contoso sample database: http://www.microsoft.com/en-us/download/details.aspx?id=18279