As I mentioned above, even administrators can deny themselves permissions. And a domain administrator can impose group policies that will also restrict what a local administrator can do. Being...

See of the database is set to AUTO_CLOSE. When closed, SQL Server releases its exclusive lock on the database files and log files. If some other process decides to back...

Never seen this before. But I think it could be worthwhile to run dbcc traceon(3604) dbcc dbtable('<db_name>'), save the results, and compare with successes.

https://msdn.microsoft.com/en-us/library/hh213291.aspx

For this...

1. Search https://msdn.microsoft.com/en-us/library/ms188783.aspx twice for filter_predicate .

2. Search https://msdn.microsoft.com/en-us/library/ms187373.aspx four times for index_value .

My concern was not about the presence of the AND 1=1 clauses - I expect SQL Server...

Create statistics on ABC.number, or create a test index on ABC.number, and examine that statistic's histogram. The partially-omitted "(ABC.Number LIKE @P1 " predicate may not be sufficiently selective for the...

Summary.txt should point to the first log to inspect (for each bootstrap log summary).

Old article, but INF: How to Restrict the Inner Table of an ANSI Outer Join may be relevant

Examine SQL Server Setup's bootstrap logs. Local admins can successfully deny themselves permissions. But there is a twist: Local administrators can also remove that deny, unless a domain admin with...

I am certain there are hundreds to thousands of hits about error 26's name resolution error message (e.g. support.microsoft.com returns 33 hits on "Verify that the instance name is correct...

I have found Adam Saxton's blogs on Kerberos useful when t-shooting, starting with My Kerberos Checklist…, but not ending with Kerberos Configuration Manager updated for Reporting Services (don't let RS...

Assign @body_format 'HTML' and concatenate its tags to the @msg. I have little experience beyond that (I use text format).

I think you will discover more noise than difference, but I could be wrong:-D. My systems run CPUs hot and use TDE, but I am certain my systems' CPU constraints...

Flags are not always selective, which typically makes them a poor indexing choice. You need to understand and follow database normalization basics (at least down to 3NF), before attempting to...

Likely to be bound by SGAM/GAM page contention in tempdb, but could be CPU bound. Should be easy to benchmark on your CPUs, with your tempdb files (mine differ). Duration...