You relied on using a feature that you are not supposed to use. RETURN is not for output parameters or values, which is what you used it for. ...

Actually read my post carefully - it is ApexSQL DataDiff, a data comparison and synchronization application from ApexSQL. As Steve pointed out RedGate makes a competing product, and there...

I restate my first idea:

1) Hire a...

Silverfox (9/29/2009)

---

TheSQLGuru (9/29/2009)

---

Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers...

Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers would make...

You need to put a filter in place IMMEDIATELY to reject any query that has the following in it. Note this is NOT a bullet-proof mechanism or list, but...

do NOT simply implement what DTA might advise. It has SIGNIFICANT limitations and will create MANY indexes with large percentages of the columns in a table INCLUDED just to...

>> but wish to know how this may affect my system

Then you should run a production workload against your production-mirrored test environment. You DO have one of those,...

Unfortunately the true solution here maybe be to simply 'tune' the view(s), which given their complexity could take many days or even weeks of effort and carry significant risk of...

I can think of 3 solutions:

1) Hire a professional to help you tune the poorly performing database. It seems that you are not a SQL Server guru so I...

Here's a possible solution. Make a complete backup of the remote database and store that on USB key. Restore that to the main server when the guy gets...

Buy FolderInfo and use it to quickly spot space consumers on the drive of concern. Very useful utility I have been using for a LONG time.

Also, instead of going...

My reply is that you should hire an expert to assist you with this matter. There are MANY things you need to do right to get optimal and reliable...

>> Note that if you are using an HP EVA SAN, then it's not really necessary anyway.

Vincent, can you please offer proof of that assertion?

To OP, Jimmy also has a...

1) this is the first of 3 blog posts that are the Bible for troubleshooting deadlocks. http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

2) If you are getting that much frag in a day then you...