Sorry, I overlooked the edition issue.

What I tried to say is that while you could investigate what is going on with your hardware, you could also consider these INSERT statements....

OK, if there are no triggers no the tables, we can exclude problems with query plans as such, but problem is related to the mirroring setup.

One way to resolve it...

dwain.c (9/1/2013)

Tools->Options->Scripting

Here you can control what...

Oops! That should be schema_id, not object_id.

SELECT quotename(s.name) + '.' + quotename(o.name), o.type

FROM sys.objects o

JOIN...

Because to install things on Windows, you typically use Windows Installer?

Or what is your question really about?

The query returns the data in true megabytes. That is, 1MB = one million bytes.

More to the point, the query counts pages in the buffer cache, and the size of...

Here is a query that gives the consumption in the buffer cache per database. I hope it is correct, but I welcome if Gail and others can review it.

select db_name(database_id),...

The reason now that you always get all rows is because you have all conditions in the ON clause. Thus all rows in the left table are retained.

I'm not exactly...

So this is a difficult situations when the server becomes unavailable during the upgrade. I would go the LOG directory for the instance and look at the ERRORLOG file to...

It would help if you included a CREATE TABLE statement for your table, as well as sample XML document. And from that example you could explain a little more closely...

I tried to discuss that in my post, but here is a more concise list of the basic scenarios:

1) Restore most recent backup + logs to the same database.

2) Restore...

Jeff Moden (8/31/2013)

It produces rounding errors when working with decimal places simply because FLOAT is based on binary math rather than decimal math and it can't actually precisely contain certain...

You probably want something like:

IF EXISTS (SELECT *

FROM dbo.TABLE

...

Some of the scenarios you list are more or less the same. If someone deletes a file from the database, this is more or less the same as if the...

This is when you use FOR XML PATH(''). A completely obscure syntax for the purpose, but it works.

declare @year int = 2013,

@week int = 27

declare @dte date

select @dte...