I hope everyone had a relaxing and safe Christmas! By default, SQL server will check for deadlocks...
Category - SQL
Applying SQL Server 2019 Cumulative Updates
Staying on top of updates is important to stay secure and have SQL Server run as efficiently as...
Options for Freeing Plan Cache
Let’s say you’re facing parameter sniffing issues for a particular stored procedure. ...
Configure Database Autogrowth
Today, I want to discuss autogrowth in SQL Server. When creating a new database, SQL Server sets...
Reasons to Run DBCC UPDATEUSAGE
One e-mail alert that we all dread receiving is an alert stating that DBCC CHECKDB found issues...
How Fill Factor Can Affect Performance
Fill factor determines the percentage of space to leave open for new data added in an index...
Set Statistics Time/IO For Each New Query Window
I doubt that I’m alone in the experience of beginning to troubleshooting a slow query, executing...
SQL Backup to Multiple Files
I recently had a project that required uploading a large database to an FTP server. Sounds simple...
Different Ways to script out stored procedures in SQL Server
Creating a new procedure is like visiting a new place ,while knowing how to script them is like...
Truncate vs Delete in SQL Server
There is always a new beginning when we get rid of the obsolete /unused /wrong data . True to the...
Methods to find Table Structure in SQL
Most of the times while working with SQL server ,we are definitely dealing with lots of tables and...
Fun with Commenting codes in SQL Server
If a working code is interesting then a code that doesn’t work is much fascinating . I have got one...
How to check Oracle Database version
Connected to an Oracle server by SQL Developer or another database management tool, do you need to...