How to change the ownership of SQL Server or Database Owner permission from one account to other.

Problem: How to change the ownership of SQL Server or Database Owner permission from one account to other. Solution: A​UT​HO​RI​ZA​TI​ON ALTER AUTHORIZATION can be used to change the ownership of any entity that has an owner. Ownership of database-contained entities can be transferred to any database-level principal. Ownership of server-level...

Read More

Transfer Schema Objects

Problem: How to transfer objects from an old schema to a new schema with in the database. Solution: ALTER SCHEMA TRANSFER This transfers the specific objects in between schemas. Syntax: ALTER SCHEMA schema_name      TRANSFER [ <entity_type> :: ] securable_name   [;]  <entity_type> ::= ...

Read More

How to Configure Database Mirroring?

Problem: How to Configure Database Mirroring? Solution: Setting Up Database Mirroring (SQL Server) Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database...

Read More

Optimize query plan memory used for Ad-hoc Queries

Problem: An application executes a large volume of dynamic queries. How to reduce the amount of memory used for cached query plans? Solution:  Optimize for Ad Hoc Workload, Starting from SQL Server 2008 A Query when gets executed...

Read More

Detach and Attach Database.

Problem: How to detach and attach a database, where will this be useful process? Solution: Database Detach and Attach (SQL Server) The data and transaction log files of a database can be detached and then reattached to the same or another...

Read More