Hi, you say in your post you still need to sign up to have access to the Big data Cluster Images. Are you sure that's still the case?

Sure, here's the link to the original SQL Server 2012 Licensing guide, page 14 onwards will hopefully help, https://www.google.co.uk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjqueDB0YHLAhVMOxQKHe58CwsQFggfMAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F7%2F3%2Fc%2F73cad4e0-d0b5-4be5-ab49-d5b886a5ae00%2Fsql_server_2012_licensing_reference_guide.pdf&usg=AFQjCNH9fa6bCvXk8bHYo7OaJGGnr78qFw&bvm=bv.114733917,d.d24 .

I will throw a disclaimer in here though,...

You're right, AWE is not required on a 64 Bit system running 64 Bit version of SQL, it could just be that what you're using that box for has not...

I agree, as with all open transactions you should check to see what it is doing and if it is actually causing a blocking problem before deciding to kill it...

I agree with the last two postings, if you're confident your database stats are correct always try and use the Dynamic Management Views to looks at the table details if...

I wouldn't recommend running this on a very large database, you'd be waiting for some time and would cause a lot of contention, and to be honest I wouldn't use...

I haven't, I know it's a fairly common issue for a lot of performance issues, just make sure you do the larger tables out of hours, especially if you're experiencing...

Basically, we has some SQL in a stored procedure which performed reasonably OK on 2000, but we found that when the same SQL was running on 2008 it performed terribly,...

It may be worth checking your physical join operators as well, as I've encountered performance issues with stored procedures during migrations from 2000 to 2008...

Just an FYI in case anyone else experiences this issue in the future, according to Microsoft these zombie Spids were caused by a bug which can occur in rare circumstances...

Ninja's_RGR'us (7/1/2010)

---

kchant (7/1/2010)

---

You could try running DBCC UPDATEUSAGE first and then using the system views to get an accurate row count, if you're using your original query with the WHERE...

You could try running DBCC UPDATEUSAGE first and then using the system views to get an accurate row count, if you're using your original query with the WHERE clause still...

Alternatively, depending on what resources you have on site , it may be possible for you to so an Open File backup of the database files of your Secondary database...

Well if anyone's got a URl to a valid download I'd appreciate it, as all the ones I've come across are either non-existent or for one chapter 🙂

Robocopy's great, use it as part of a log shipping solution, I'd recommend not implementing any logging if moving large files though...