What are the issues with the Excessive use of system DMVs in SQL Server?
Excessive use of system Dynamic Management Views (DMVs) in SQL Server can lead to various issues. Firstly, querying DMVs can be resource-intensive, causing contention on the server, and generating a lot of data, leading to increased disk space usage and server...
How to change the data type of a column in a table
To modify the data type of a column: Please note: Whenever making a change to a table structure there is a chance that change may result in data corruption if not done correctly, which is why it is would advisable to take a backup/copy of the table on which you intend...
Difference between the database management system and SQL
Difference between the database management system and SQL What is a management system (DBMS): DBMS could be a group of programs used for managing information and at the same time it supports different kinds of users to build, manage, retrieve, update and store data....
What is XP_DIRTREE? What are the alternatives to XP_Dirtree
This extended and undocumented stored procedure can be used to list all folders and subfolders (recursively) from a given directory. XP_DIRTREE has three parameters: Directory – This is the directory you pass when you call the stored procedure; for...
The only audit you'll need for production databases!