Retries index cannot be used because it has operators applied to it before comparison, it is not "naked" attribute.

Index on LastUpdateTime should be used because you need TOP 100 ordered...

Try uninstalling completely and installing some other edition/version of SQL2012.

You will not get lock escalation once you simplify your query. 100 rows is not near the escalation threshold, especially if you have right indexes. Check execution plan of your...

You join TableA with cte which also is TableA, on ID field. Get rid of the hints, get rid of the cte, get rid of the join. It's a plain...

Bcp out each table using native format, then bcp in those 3 files into dev db. It is very fast method, approx 100 000 rows per second on my old...

XACT_STATE() is irrelevant here. Value of -1 means we are in uncommitable transaction and our only option is to rollback.

Since we are doing rollback anyway, checking XACT_STATE() is irrelevant. It...

In VM configuration set "RESERVED MEMORY" to at least half (or better - all 64GB) of the RAM you allocated for that guest.

That will prevent the ballooning driver in your...

You are doing circular trigger firing:

CREATE TRIGGER ...

ON dbo.ExceptionInstanceTemp -- trigger fires on insert command

INSTEAD OF INSERT

AS

BEGIN

INSERT dbo.ExceptionInstanceTemp --...

There is a bug if you grow in 4gb multiples. See http://www.sqlskills.com/blogs/paul/bug-log-file-growth-broken-for-multiples-of-4gb/

Use 8000mb instead of 8gb

JKSQL (2/15/2013)

---

I create the DB, and then package it in an installer. That installer is then run on a server outside my control. I have to guarantee that...

"public" is a database role.

"grant execute to public" grants to public database role a permission to execute any executable object (procedure, scalar function) within a database. That is why there...

Did you actually tried to execute a procedure or you concluded it doesn't work without trying because you do not see object grants as before?

Thanks Gail for the definition. But that does not change the fact that read committed snapshot is not the same as read committed even in terms of "anomalies". "Read committed...

Bravo! I used "allow inprocess" to make some db links to work (e.g. when connecting to oracle), but completely forgot that maybe that can help your case.

Integrated security and trusted connection are the same thing. For security reasons it is better to use them instead of hard coding a password into connection string. Min and max...