Recovery Models in SQL Server
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 …
SQL Inner Join Tutorial with Example: Managers with at Least 5 Direct Reports
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) …
The Algorithm to Construct the Rectangle Given Its Area
For a web developer, it is very important to know how to design a web page’s size. So, given a specific rectangular web page’s area, your job by now …
How to Find Positions of Large Groups using Two Pointer Algorithm?
In a string S of lowercase letters, these letters form consecutive groups of the same character. For example, a string like S = “abbxxxxzyy” has the groups “a”, “bb”, …
IPv6 Is Dominant, But Has The World Actually Moved On?
The changeover from volume-limited IPv4 to IPv6 launched 6 years ago, and now, according to Internet Society, IPv6 is dominant. 25% of connections to Google services, a bellwether for …
How to Find the Town Judge using Graph Algorithm?
In a town, there are N people labelled from 1 to N. There is a rumor that one of these people is secretly the town judge. If the town …