Iron Maiden tickets blimey that takes me back. Saw them a good few years ago twice at the Birmingham NEC and once as a student in Portsmouth Guildhall. Was excellent...

we get this quite a lot but then its a big environment. Usually we can correct with an sp_recompile to get the plan rebuilt once we've analysed the issue. Often...

I think it shows the progress of this type of thing when my Open university course includes pieces about it. I think its going to become mainstream whether we like...

Great question introduced me to some SQL 2012 functionality I've not come across before.

What parameters if any are you using and what is the size of the data returned ?

Is the job running at the same time as any system backups ? volume shadow copy or and disk snapshots ?

So if you get enough of them can you build a SAN ? that way when performance goes bad at least you can pick it up and shake it. Was...

adonetek don't know if you can change the code but this is exactly why they brought in the try\catch block to allow this kind of operation. Looking at your code...

Oh and I forgot to mention compatibility mode does have its pitfalls while it affects SQL Syntax and Query parsing there are some known issues with strange performance occurring after...

You can upgrade 2008R2 to 2016 although there are a few steps and hoops to consider. Found the following a useful resource

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server

While I can see the need for questions, surely its more about the fit and the leverage you have for change. Most of those first questions are easily fixed if...

Encyclopedia Britannica I remember those my nan had a set not that we where ever allowed to look at them. It was more an image thing. They sat in that...