Having said all that, I might be missing it, but I don't see in the Aaron Bertrand article you reference where he suggests generally setting MAXDOP=1. It's listed by MS...

I've tested your code and it works without returning the overflow error. Are you sure the error is in this line? Could you post more of the code?

Minor correction to...

I looked at the table variable row estimation as a possible issue, and by default the table variable estimates 1 row, but it returns 145. I would expect this to...

I'll see what I can do, but I've had to change the schema information for this post as this is a client's database. I'll need to get their permission to...

I would recommend looking at disk performance on both ends and connectivity.

I'm backing up a 600GB database in 12 - 14 minutes using SQL Native.

Check the following: Are the data...

What we do in the first step is raise an error to force the step to fail

Test for Secondary for the AG

....

If @Secondary = 1

BEGIN

RAISERROR(''Running on Secondary Replica.'', 11, 1)

END

Then...

Thanks Perry. At this point I've built a whole lot of 2012 and 2014 AoHA environments for various clients so know this well. The current proposal is for a client...

Within reason this is true however the virtualised environment Jonathan's...

Good question, I'm depending on the client for this, so we'll never know. I've not been able to find anything in the log to confirm this. The next step is...

GilaMonster (11/3/2013)

---

All new features (well, vast majority) work in lower compatibility levels. Compat level just affects how the parser and query processor handle certain T-SQL structures that have changed over...

You can create an identical, empty table (same columns only) by using: select top 0 * into New_Table_Name from My_Table

How many rows are there in your problem table and how...

I'd go back to Red-Gate. There's an old article that implies this may be a result of timeouts between the monitoring app and the SQL Server that causes false alerts...

Is this OLTP or data warehousing?

For OLTP on SQL Server 2008 there's still justification for setting MAXDOP to 1. Ideally you shouldn't have any OLTP queries needing multiple cores, and...

Is it possible you have a very, very, very large transaction in the log file that needs to be rolled forward/back?

Cheers

Leo

We use database mail extensivly to report server information back to a monitoring environment. Typical issues we see are things like the mail server name is wrong or the SQL...