The following implementation helped me in analyzing the disk space usage.   There are many ways to get the available disk space in the ser...

Almost a decade before , I came across a requirement where I needed to add multiple columns in a table with default value . It too...

SQL Server "Replicate" Function repeats a character expression to a specified number of times. It is equivalent to or alternative ...

During the deployments, windows patching or any other activity, DBAs often disable the jobs to avoid data corruption and jobs failure. Once ...

Please refer to my previous post in which schema and data for EMP and DEPT tables available. In this article we are about to discuss a...