SQLOPS IS THE ONLY AUDIT YOU’LL NEED FOR PRODUCTION DATABASES
Best Practices for MAXDOP in SQL Server
MAXDOP (Maximum Degree of Parallelism) is a configuration option in SQL Server that controls the number of processors that can be used in parallel execution of a query. Here are some best practices for using MAXDOP in SQL Server: Set MAXDOP based on the number of...
Best Practices for Managing Duplicate data in SQL Server
There are several problems that can occur when dealing with duplicate data in SQL Server: Data integrity issues: Duplicate data can lead to inaccuracies and inconsistencies in your data. For example, if a customer's information is duplicated, it can lead to multiple...
Best Practices for handling data anomaly in SQL Server
Data anomaly refers to the inconsistencies and errors that can occur in a database. These anomalies can be caused by a variety of factors, such as human error, software bugs, or system failures. There are several types of data anomalies, such as: Insertion anomaly: It...
Avoiding Cursors in SQL Server
Cursors in SQL Server allows you to traverse through the rows of a result set one row at a time. It is essentially a pointer that points to a specific row in a result set. Cursors are used to perform operations on a row-by-row basis, such as updating or deleting...
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...
Find missing indexes and improve query performance
Find Missing Indexes before going into production Find missing indexes the right way! First of all, finding a missing index is not a rocket science. Always find and create missing indexes before you deploy the code to the production environment. DBA's and engineers...
What are users executing from SSMS
What are users executing using SSMS? During a customer review meeting, one of the DBA asked if there’s a quick way to find out What are users executing using SSMS. Though this information can easily be obtained from SP_Who2 system stored procedure, the DBA wanted to...
