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...

There are a number of reasons to rather do an OFF LINE rather than a DETACH when moving database files like this. In SQL 2005 there was a particular issue...

Using MDF, NDF & LDF is really historical and convention more than anything else, it does however allow the files to be easily identified as database files. When you move...

This PDF from Microsoft is quie easy to understand "SQL 2012 Licensing Datasheet" and can be found with a search on Google, but try get the latest version.

The 2 x...