There are two things that affect the frequency of log backups.

1) How big you are willing to let the...

Personally for a Y/N column, I'd use CHAR(1). Yes, it could be a BIT, but that requires additional logic in every query and unless there are other bit columns in...

Unless you have a really good reason for wanting a duplicate index, or there's a major performance degradation when you remove it, take it out. SQL will use the cheapest...

What do you mean by 'rotated'?

Restart won't do anything to the database transaction logs, they'll be read when the server restarts in order to do restart recovery, but a shutdown...

SQL Server Error log.

There's also a chapter in the MVP Deep dives book - http://www.sqlservermvpdeepdives.com/

For many counters there's no single threshold where below is good and above is bad, it's not that easy. For many, you need a baseline for what's normal in your...

I assume you...

Can you also try a statistics update with full scan on the Drivers table? The row estimates are way off, probably contributing to the poor plan. Weird thing is, there...

Can you give me the definition of this index please

[tblAUPolicy].[_dta_index_tblAUPolicy_7_357576312__K2_K115_K1_112_113_114_116_117_118]

In fact, can you give the definitions of all the indexes on that table?

Maybe, if you can post the full stored procedure, some info on the tables and indexes and the execution plan, as previously...

Considering there are range shared locks involved, probably yes. Question is, is serialisable needed. If not, dropping to repeatable read or read committed will probably make this go away....

Can you post the definitions of the two procedures involved (QDB_Central.dbo.uspUpdateOrgUnitAcknowledgements and QDB_Central.dbo.EnqueueMessage), the definitions of the table involved (QueueData) with all of its indexes.

Why are you using the serializable...

It's using the clustered index when you do SELECT * because the cluster contains all the columns and you're asking for all the columns. If it used the nonclustered index...

Brain dumps are cheating. They are questions taken from the actual exams, in violation of the NDA that anyone taking the exam has to accept. Using or distributing braindumps can...