WordPress.com

SET FOREIGN_KEY_CHECKS = 0;
truncate table `table_name`;
SET FOREIGN_KEY_CHECKS = 1;

Azure SQL > User initiated manual failover on SQL Managed Instance

https://techcommunity.microsoft.com/t5/azure-sql/user-initiated-manual-failover-on-sql-managed-instance/ba-p/1538803

High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications. 1,844 more words

-- Union ----------------------------------------------------


-- Find a list of employee and branch names
SELECT employee.first_name AS Employee_Branch_Names
FROM employee
UNION
SELECT branch.branch_name
FROM branch;

-- Find a list of all clients & branch suppliers' names
SELECT client.client_name AS Non-Employee_Entities, client.branch_id AS Branch_ID
FROM client
UNION
SELECT branch_supplier.supplier_name, branch_supplier.branch_id
FROM branch_supplier;

Download Sample hr database.

1.How to find Third highest salary in Employee table ?

select

I finally had a good use case to makeuse of PIVOT functionality!

Problem to address: Database integrity check on a very large database (12+ TB) with high transactions has been failing due to Fragmentation limit on sparse file (Snapshot file during DBCC Integrity Check). 206 more words