Category: database
Querying the Database e.g. MySQL could be very expensive relative to just a cache which is just a key value store . And for SELECT statements, we want to …
Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and …
Given the following SQL Schema, CREATE TABLE If Not Exists point_2d (x INT NOT NULL, y INT NOT NULL) Truncate table point_2d insert into point_2d (x, y) values ('-1', …
When we talk stuff related to SQL Server and database, Recovery is an imperative objective that one shouldn’t underestimate. With Microsoft SQL Server, there are three different Recovery Models …
Given the following SQL Schema: Create table If Not Exists Employee (Id int, Name varchar(255), Department varchar(255), ManagerId int) Truncate table Employee insert into Employee (Id, Name, Department, ManagerId) …