Tags » SQL

Sql truncate with foreign Key

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

User initiated manual failover on SQL Managed Instance

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

Azure

Explore Chocolate with MySQL Workbench

Anyone who knows me for long must have learned I am a crazy fan of chocolate. Whenever I need some pick-me-up, a block of Dark Chocolate with Sea Salt will make my day. 2,534 more words

SQL

Tutorial - 11

-- 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;
Programming

SQL

Download Sample hr database.

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

select
SQL

The WinVerProject

If you’re an MSP and you need to keep track of your customers Microsoft Windows 10 versions, you might have already turned to Power BI to make sense of all that data exported from your RMM system. 691 more words

Power Platform

Practical use of PIVOT in MSSQL

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

SQL