The following implementation helped me in analyzing the disk space usage. There are many ways to get the available disk space in the server and
Adding Multiple Columns With Default Value
Almost a decade before, I came across a requirement where I needed to add multiple columns in a table with default value. It took a
SQL Server – Replicate Function
SQL Server “Replicate” Function repeats a character expression to a specified number of times. It is equivalent to or alternative of Oracle’s RPAD function. Let’s’
Alert on Scheduled SQL Jobs – Missed to enable
During the deployments, windows patching or any other activity, DBAs often disable the jobs to avoid data corruption and jobs failure. Once the activity is
Analytical & Window Functions
Please refer to my previous post, in which schema and data for EMP and DEPT tables available. The topic of this post is SQL Server
Oracle SQL Emp and Dept Tables For SQL Server
Below are Oracle’s most popular “emp” and “dept” tables compatible with SQL Server. — Table definition – Dept CREATE TABLE Dept( DeptNo INT, DName VARCHAR(14),
Big Data & SQL 