It could be due to an Always On Availability Group 'Failover'...
Whenever I have a running query, connected to an AG Listener (and to one of the AG databases), and...

Perry Whittle (3/2/2015)

---

on the secondary instance expand the Always Availability section. Expand Availability databases and you should see a little pause symbol on the database rather than a green arrow....

Hi, yes, I fear you are right 🙁 I haven't found anything that seems to indicate that I can reuse the original backups and Not take new ones for doing...

Thanks!

Yes, I specifically would like to try to avoid that. My Full backup is around 1.5 TB and the drives of the new datacenter are slow 🙁

I was thinking, since...

Hi,

Yes, I had accedentally left out the best part (the SWITCH code) :/

I have now edited my post...

Regards,

Hans

In SQL Server 2014 (maybe also in earlier versions) SWITCHing unpartitioned tables is easy.

Example:

(Summary: SWITCHing between T1 and T2)

--Table/Index creation

CREATE TABLE [dbo].[T1] ( [A] [INT] PRIMARY KEY);

CREATE TABLE [dbo].[T2] (...

When you 'see' it in profiler, might you be experiencing an IMPLICT_CONVERSION of your column type?

I.e. your application passes, for example, an NVARCHAR (for comparison) and the column type is...

I know this thread is old but maybe this can help someone:

The MS Connect item

points to the KB in question which, in turn, points to the CU...

A good summary of 'xp_readerrorlog' can be found here:

http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/

Thanks guys.

Ok, so RESTORE DATABASE currently works when restoring transaction log backups (I also tested using the STOPAT parameter)...

This is not something I have seen documented anywhere and I fear...

Well, the theory says that SSDs would also be affected...

I.e. any partition created on an SSD would have to be aligned. Care should here be taken as the specific SSD...

Very good question!

I hope this raises the awareness of the issue as it has constantly been an uphill struggle, in the past, to enforce partitioning alignment...

OK for a 'creativity' query but I feel this does not go well with RDBMS theory...

Extract 'Odd' lines from an unsorted list? How can anyone treat the Expected Results as...

Hi,

I'd like to...

Matt,

Any specific reasons you wouldn't go for:

CREATE NONCLUSTERED INDEX IX_OrderDetailDateProdSold ON dbo.OrderDetail

( ProductID ASC, OrderDate ASC)...