A reader asked how to add several columns with default values to an existing table. Here is a simple example to add multiple new columns with defaults.
What is a Self Join? Explain with Example – Interview Question of the Week #064
What is a Self Join? It is a popular interview question for every developer. Here is a simple answer, whether it is inner or outer, and a practical use.
SQL SERVER – Patch Upgrade – Failed to connect to server. Error: 0x80070422
A client’s SQL Server 2008 R2 SP2 patch failed, and the setup logs showed Failed to connect to server, Error: 0x80070422. Here is how we traced and fixed it.
SQL SERVER – Extended Events to watch for using ColumnStore Index
Profiler can’t show how ColumnStore indexes work, so a DBA friend asked which extended events to watch. Here are my notes on the events worth tracking.
SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?
hey incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable.
Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?
After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed. Let us fix the error in this blog.