SQL Server performs garbage collection of row versions when ever it needs to, i.e. when there is memory-pressure that causes it to do so. Garbage collection for row versions cannot...

I realize this post is slightly old, but wanted to give some feedback --

Keep in mind that FK on memory-optimized tables can only reference other memory-optimized tables. 

Just keep in mind that if REDO falls behind for any reason, backups on the Secondary will only capture up to the point of REDO, no matter how far behind...

Also note that the compatibility level of a database is not necessarily the same as the version of SQL Server that it is hosted in (please forgive formatting errors in...

There are two processes that run on the Secondary:

1. hardening of the log

2. REDO (replaying of the log)

Not sure if this is what you're running into, but the Syncronization state...

your task will be much simpler if you keep backups in separate files. I would also suggest using Ola Hallengren's backup scripts instead of maintenance plans, which can have some...

if you don't know how many clients the web site will have, I don't see how your customer can use CAL.

Just found this, which may be viable, but is sort of a brute force way to do it:

http://itknowledgeexchange.techtarget.com/sql-server/deleting-lob-data-and-shrinking-the-database/

sqlnyc

Hi Scott and Steve - thanks very much for your replies.

I've emailed Paul Randal about this in the past.

His reply was:

"The issue is that LOB extents are not...

Hi Steve,

Thanks very much for your reply.

I will research the link you posted.

Long ago, when this server was running SQL 2008R2 RTM, there was indeed an issue with...

Hi Luis,

Thanks very much for your reply.

I want it to fail if it's an empty string. Your suggestion of NULLIF() worked.

Much appreciated.

SQLNYC

It appears that the index was disabled.

my apologies, that should have been without the IDENTITY:

CREATE TABLE [dbo].[t1]

(

[col1] [int] NOT NULL

,[ProcessedDate] [datetime] NULL

,[col3] [int] NOT NULL

,CONSTRAINT [UQ_T1_Col1_ProcessedDate_Col3] UNIQUE NONCLUSTERED ([col1] ASC, [ProcessedDate] ASC, [col3] ASC)

WITH ( PAD_INDEX...

Hey MyDoggieJessie,

Thanks so very much for your replies.

All disks are local to the server, no DAS or SAN yet.

MDFs: 6GB/s SATA SSD

LDFs: 6GB/s SAS 15K spinning

In general, we...

Many thanks to all that replied.

I simplified the example to (hopefully) make it easy for others to help me. The code as originally written has the following WHERE clause:

WHERE...