It has nothing to do with mirroring, it's the default behavior of identity columns in SQL Server 2012 and up. Identity columns are preallocated and when the database goes offline...

And the question is?

We're naming the scripts with a timestamp prefix, such as YYYYMMDDhhmm. All scripts are applied following that order.

First of all, check whether the collect and upload jobs are working fine.

Then, check if any data is available in the MDW database. Check the core.snapshots_internal table in particular (you...

GilaMonster (1/19/2016)

---

dm_sql_referenced_entities is 2008 and above. sys.sql_dependencies can be inaccurate, as procedures can be created before the tables they reference, if they are the dependency info won't be there. No...

You can use the catalog view sys.sql_dependencies to extract the information you want. See here for more detail: https://msdn.microsoft.com/en-us/library/ms174402(v=sql.90).aspx

Ah, I see. Sorry for the confusion.

To achieve what you describe, you need IIS installed. I have done this in the past and it works, but, again, it needs...

I can say what we have. Might or might not work for you.

First of all, avoid DPM like the plague. It does the dumbest things you could ever think of....

The best way to audit is probably... surprise... an audit!

It's an enterprise only feature, so no joy if you're running on standard edition. In that case, the options you already...

You can configure a SSRS url in the configuration manager. Make sure you match your URLs with the DNS configuration (e.g. CNAMEs).

Hope this helps,

Gianluca

What's your problem exactly?

You have two options:

1) Distributed replay

2) RML utilities

Both tools support replaying the workload in "synchronization mode", which is to say that queries are run at the same rate they...

Any errors in the cluster log?

The plain SELECT and the INSERT...SELECT are probably using two different query plans: compare the two and find out where the perf problem lies.

Another possibility is that the INSERT...

This should do:

SELECT

name,

sizeMB = (

SELECT SUM(a.total_pages) * 8.0 / 1024

FROM sys.indexes AS i

INNER JOIN sys.partitions AS p

ON i.object_id = p.OBJECT_ID

AND i.index_id = p.index_id

INNER JOIN sys.allocation_units...