A Patch in AlwaysOn Availability Group needs a sequence matched to the topology. I start this two-replica example with the secondary.
SQL SERVER – Add Failover Cluster Node Fails With Error – This SQL Server Edition Does Not Support the Installed Number of Cluster Nodes
Add Failover Cluster Node failed: this SQL Server edition does not support the installed number of cluster nodes. What Detail.txt showed and how to fix it.
SQL SERVER – Unable to See Tables (Objects) in SSMS
A client could query a table but was unable to see tables in SSMS Object Explorer. A DENY permission was the cause. Here is how I tracked it down.
Slow Database Creation in SQL Server: Causes and Fixes
Slow database creation in SQL Server comes down to its files: how big they are, and whether SQL Server must zero every byte. This post checks the three usual suspects, the size of the model database, instant file initialization and the log file, and times each one with a script. It also shows the wait type to look for while a large CREATE DATABASE runs.
How to do Pagination in SQL Server? – Interview Question of the Week #111
How do you do pagination in SQL Server? A popular interview question. Instead of pulling every row into the app, here is a method that returns just one page.
SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.
A query ran fine in SSMS but failed in an Agent job with error 1934: SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Here is the simple fix.
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
I broke my own SQL Server by editing startup parameters. Here is how the ERRORLOG helped me fix error 17113, error opening master.mdf at startup.