Best Practice No.36
Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it
Read moreLet's learn together!
Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it
Read moreFew months ago I started a series where I explained all about Execution Context & Context switching, you can use
Read moreIn your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough.
Read moreHi Friends, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this
Read moreCheckpoint is an internal process that writes all dirty pages (modified pages) from Buffer Cache to Physical disk, apart from
Read moreRebuild only those Indexes where the fragmentation level exceeds the threshold value of 30.
Read moreConfigure a dedicated NIC (network card) card for your Backups on your busy systems.
Read moreAlways use SQL Server Configuration Manager to change Service account for any SQL Related Service.
Read moreMigrating SQL Server jobs from one server to another is a critical task and there are many alternatives available for
Read moreWhile referring objects in Stored Procedures, functions, views and Triggers always use Fully Qualified (Multi Part) Name of the object.
Read more