Mike Good (5/27/2016)

---

Nice question but now I reckon I don't properly understand this. I compiled the proc w/out modification, using my sysadmin login, but when I run it I...

The amount of space within the log file that is actively being used can fluctuate based on several things, including backups, active transactions, replication, Availability Groups, etc.

What you're seeing is...

Heh, been there more times than I'd care to admit 🙂

drew.allen (5/26/2016)

---

Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in...

Exactly how are you comparing the before and after results (the query used)?

For the trace, are you sure there are no filters configured? Exactly how are you querying the trace...

ramana3327 (5/24/2016)

---

Do you mean

The alter database to restricted mode is failing because some other sysadmin connection is being used that time.

This is exactly running in step1

BEGIN

DECLARE @kill varchar(8000) = '';

SELECT...

Pretty sure it requires sysadmin.

There's an active Connect item complaining about this: https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug.

The Microsoft engineer who responded initially said:

The minimum security requirement is sysadmin. This is by design from...

Additionally, the clustering key is included...

If 1) this really is all in a single job, 2) the ALTER DATABASE ... SET RESTRICTED_USER is in the first job step, and 3) the first job step is...

I've found that most commonly people hit that error when there's an ALTER DATABASE command to change the state of the DB that has not yet completed, usually because the...

Is it possible, i.e., not a logical contradiction? Sure.

All it takes is for the queries blocking one another to tax a resource (most likely CPU or storage) for which response...

The most common cause of this is that the database is using the full recovery model but log backups are not being taken.

Check on that first.

Another common cause is a...

sqlnaive (5/17/2016)

---

Interestingly, what I found is suppose in Table overall I have 1000 records and after all the joins with other tables I get 200 records and in those 200...

Ah, if you can check all the distinct dates, then it must be a small(ish) list.

Any chance of posting sample DDL and data that recreates the issue, or even just...

And I had explained how the inclusion of other columns could lead to such a...