A SQL Agent job failed with: The job failed. Unable to determine if the owner of the job has server access. Here is how I fixed this error in my lab.
Which is Faster – INSERT INTO SELECT or SELECT INTO? – Interview Question of the Week #187
Which is faster, INSERT INTO SELECT or SELECT INTO? A client moving large data between tables asked me, and here is what we found when we tested both.
SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
On my broken replication lab, removing a publication failed with: Could not delete the subscription at Subscriber ‘SubServer’. Here is the command that fixed it.
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting. Let us fix that in this blog.
Decoding wait_resource: From a KEY or PAGE Lock to the Table
Decode wait_resource for blocked requests, map KEY and PAGE locks to objects, and keep undocumented row-hash checks on test copies.
SELECT COUNT Without FROM Returns 1, Not an Error
A SELECT COUNT without FROM does not fail in T-SQL. It returns 1, because the table name after COUNT(*) becomes a column alias. This post shows the typo, the other silent mistakes that work the same way, and the habits that make them fail loudly.
What is Lock Pages In Memory? – Interview Question of the Week #186
What is Lock Pages in Memory? It keeps data in physical RAM instead of paging it to disk, and here is the gotcha and how to enable it step by step.