How to select records using StoredProcedure and GridView in asp.net <%@ Page Language="C#"...
Category - SQL Server
SQL Mirroring, Preserving the Log Chain During Database Migrations
Database mirroring has been deprecated since SQL Server version 2012 and now with the advent of SQL...
Missing Index Recommendation Column Order
Missing index recommendations are helpful but are not to be 100% trusted. Blindly creating...
Don’t Overuse DEADLOCK_PRIORITY
I hope everyone had a relaxing and safe Christmas! By default, SQL server will check for deadlocks...
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...