I got many questions from the users and I have listed them in today’s blog post. Let us discuss 5 Questions about the OUTPUT Clause Answered.
SQL SERVER – Create Table From Another Table
One of the DBAs from the recently asked me if I know any easier way to create a table from another table without generating a CREATE TABLE script.
SQL SERVER – Datatype Storing Unicode Character Strings
I explained how Unicode datatype works, you can read that blog here SQL SERVER – Storing a Non-English String in Table – Unicode character strings.
SQL SERVER – Storing a Non-English String in Table – Unicode Strings
Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.Â
Heroku – How to Deploy Postgres Add-Ons?
Recently I was helping one of my clients on Performance Health Check, they asked me if I know how to Deploy Postgres Add-Ons on Heroku.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.
SQL SERVER – Simple Recovery Model and Restrictions
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?