Specifically re: Replication

Replicating up-version and down-version are officially supported but there are limitations usually related to the lowest version in the topology:

Using Multiple Versions of SQL Server in a Replication...

It could be one of countless things. I would start by checking the most expensive queries by CPU.

edit:

The whole story:

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/%5B/url%5D

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/%5B/url%5D

Links?

Personally I would go with Logins based on Windows (Active Directory, AD) Groups in some cases and Logins based on individual Windows Accounts in others. It really will depend on...

From SQL you can use this to find the total amount of memory SQL Server is using:

SELECT cntr_value / 1024.0 AS TotalServerMemoryMB

FROM sys.dm_os_performance_counters

WHERE counter_name = 'Total Server...

Sometimes the error messages can be red herrings, but other times they say exactly what needs to be done. Have you tried doing what the error message suggested?

Magical Horn (8/28/2012)

---

Hello All,

I'm just about trearing my hair out with a Connection problem when I'm writing to an Excel Binary Workfile. This is the situation:

I have two Excel 2010...

Multi-tenant databases that employ the 'single-database, schema-per-tenant' model is one case where leaving the schema out of a query is appropriate. Other than that I have to agree on all...

This will help you with blank sa passwords and can easily be extended to check all logins for a blank password.

Using PowerShell to Audit for Blank SA Passwords By K....

What two documents?

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Jeff Moden (9/21/2012)

---

opc.three (9/20/2012)

---

Jeff Moden (9/20/2012)

---

opc.three (9/20/2012)

---

The less attack surfaces the better. If you're only worry is against the SQL-ninja then sure, nothing will stop them. The...

I think you would need to watch for anything that can change the enabled flag in msdb.dbo.sysschedules as well as anything that can add new rows to msdb.dbo.sysjobschedules.

I think this...

Matt Miller (#4) (9/21/2012)

---

...truncated for brevity...

I'd also add in that the markup isn't purely for presentation purposes. XML comes with a lot of tooling...

You can transfer logins and maintain the SID and password hash directly from 2005 to 2012 using the methods in this article:

http://support.microsoft.com/kb/918992

tim_harkin (9/21/2012)

---

opc.three (9/19/2012)

---

Jeff Moden (9/18/2012)

---

And some folks wonder why I/O is one of the biggest bottle-necks on some servers. Imagine what it would cost to get a 300% improvement...

Jeff Moden (9/21/2012)

---

opc.three (9/20/2012)

---

Jeff Moden (9/20/2012)

---

opc.three (9/20/2012)

---

The less attack surfaces the better. If you're only worry is against the SQL-ninja then sure, nothing will stop them. The higher we raise...