Question: How to Know Backup Speed in SQL Server?
Answer: It is very simple to know the backup speed in SQL Server. Let us discuss today.
HAS_DBACCESS Function: List the Databases You Can Open
The HAS_DBACCESS function tells you whether the current login can open a database. One query over sys.databases turns it into a list, and this post tests six databases to show what each zero means: no user, offline, restricted or a busy single user slot.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275
Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
Insert Workload Waits: WRITELOG and PAGELATCH_EX
Insert workload waits come down to two names, WRITELOG and PAGELATCH_EX. This post runs 16 connections that insert one row at a time and reads their waits with a tested script. It explains what each wait means and where to look for a fix.
Writing Rerunnable Deployment Scripts for Database Changes
Write rerunnable deployment scripts with guarded schema changes, version records, and a dry run on a restored database copy.
SQL SERVER Management Studio and SQLCMD Mode
Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.