anyone?

anyone?

any changes to the environment or databases, i.e. LOB data, MAXDOP settings? Do you use SORT_IN_TEMPDB? Do you have an idea of what fragmentation was like before and...

fantastic......

anyone any ideas? thanks

Hi,

This might be of interest:

http://blogs.msdn.com/b/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

I'd have thought for the sake of avoiding these repeated debates, it'd be worth taking the extra 2 seconds to put the version in the question...

i'm using the Upgrade Advisor. At the point where you select the databases that you want to analyse, there's also an option to analyse trace files output by profiler

that's worked. thanks again

ok, will do. I thought I'd got it working previously, obviously not.

Thanks for the suggestion

Andrew

Hi,

Could you try:

if object_id('tempdb..#temp_StartingValuesBaseData') is not null

drop table #temp_StartingValuesBaseData

Cheers,

thanks again. I've already got the precision and scale another way, but I'll have a look at putting this in instead. thanks, Andrew

Cadavre (1/24/2012)

---

SELECT DATA_TYPE,

CASE WHEN CHARACTER_MAXIMUM_LENGTH = -1 THEN 'MAX'

...

I didn't even look past turkey, yum

I'd believed that the log backups ran from the point the last full backup was taken... that was why I (incorrectly) assumed taking the copy_only backups was the way to...