DCL
SQL Command Types Explained: DDL, DML, DCL, and TCL
Study the role and the distinction between the types of SQL commands: DDL, DML, and DCL, and TCL utilized to control and create the structure of the d...
Becoming a Successful Database Administrator (DBA)
A Database Administrator (DBA) is the one who designs, implements, maintains, and solves database problems. The major objective of a DBA is making the...
SQL Server Joins Explained Simply
In SQL Server, joins are used to combine rows from two or more tables based on a related column between them.
LEN() vs DATALENGTH() in SQL Server – Easy and Clear!
LEN() function in SQL Server provides the count of the total characters in a string not counting rear spaces; DATALENGTH() gives out the total numbers...
Finding Top 10 Queries That Use CPU in MS SQL Server
This query can be used to get the 10 most CPU consuming SQL statements and will assist the DBA with the identification and optimization of costly bott...
SQL Server CASE Statement – Simple Explanation
The CASE statement in SQL Server is used to add conditional logic to your queries. It works like an IF-THEN-ELSE statement, allowing you to return dif...
