Duplicate post.

Repliese here please: http://www.sqlservercentral.com/Forums/FindPost1641346.aspx

It is expected. Triggers slow down writes to the table.

This is one of main downsides of merge replication.

If the cache is cleared, a new plan is needed for each statement.

If the stats are stale, the plans are compiled against stale stats. All the objects referenced by...

Stale statistics could be the cause.

Plans compiled against stale statistics are more likely to be sub-optimal.

It depends on many factors.

Generally speaking, if the linked server is a SQL Server, the query CAN be executed as a pass-through query and the predicate is evaluated ad the...

Not sure it's the first choice, but I assumed the list of columns...

You need a dynamic PIVOT.

Looks like this does the trick:

DECLARE @sql nvarchar(max)

SELECT @sql = STUFF((

SELECT DISTINCT ',' + QUOTENAME(Metric)

FROM TEST

FOR XML PATH(''), TYPE).value('.','nvarchar(max)'),1,1,SPACE(0))

SET @sql = '

SELECT *

FROM TEST

PIVOT (SUM(Data) FOR...

Licensing is a complex matter and it's easy to get things wrong.

That said, as far as I know, if you have a MSDN subscription you should be entitled to a...

What comes to my mind is that all the sessions using the standby database have to be disconnected when...

Assuming the clients are connecting directly to the database, this should do:

SELECT client_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@spid

If this is a web application or runs on any sort of application server,...

SQL Server Express has a limit of 10 GB per database.

Actually, in SQL Server 2005 the limit was 4 GB, so you must be using some version from 2008R2...

Voted... a couple of years ago 🙂

Yes, exactly as any other kind of query.

I have a Powershell script for that: http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/

Hope it helps

Use this:

@Databases = 'USER_DATABASES, -YourVLDB'