What are you looking to monitor? Just server health and alerts? SQL Monitor does that. If you are looking to performance troubleshoot, you might look at SQL Sentry's Performance Advisor...

First, it doesn't matter what you might have in Excel. You need to know what's in SQL Server.

Second, formatting your code will make a lot of this easier for everyone.

Third,...

You want to be really careful with functions. You can cause lots of performance issues with using them.

That being said, it looks like you are passing unitprice and not product...

Does this help? http://voiceofthedba.wordpress.com/2011/05/23/collation-conflicts-in-a-sql-server-join/

Which add-in?

My suspicion is that you will still have the 30 day period, or some period for failovers. MS hasn't typically made changes there. I could see AlwaysOn only giving you...

Ninja's_RGR'us (11/10/2011)

---

We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's 10...

GilaMonster (11/9/2011)

---

Roy Ernest (11/9/2011)

---

Steve will rip my article into pieces for sure. I am not a writer. Therefore I expect to have problems with the Steve Editor as well. ...

GilaMonster (11/9/2011)

---

SQLRNNR (11/9/2011)

---

GilaMonster (11/9/2011)

---

Roy Ernest (11/9/2011)

---

Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was...

I would agree with Brandie that you want some baselines for each report before you go larger scale.

The other thing I might check is running a load test of the...

SQL Kiwi (11/9/2011)

---

Roy Ernest (11/9/2011)

---

Darn, I was submitting an article here and as soon as I uploaded an image, it removed all the previous text I entered. That was painful....

Koen Verbeeck (11/8/2011)

---

Steve Jones - SSC Editor (11/8/2011)

---

I'm sure you'll pass me. I am down to about 150 posts a month, too busy with other stuff and most questions...

djackson 22568 (11/10/2011)

---

Steve,

In your post you made reference to "my patterns" and other phrases that seem to indicate you own the data. That could not be further from the...

SQLDCH (11/9/2011)

---

There's a game tomorrow night (Thursday, November 10th). There's still plenty of things that can happen, the division leads are wide open and lots of potential in the...

some good ideas above. The key is do you want the table backed up to move to another database, or stored outside of SQL Server or are you trying to...