Category Archives: SQL Server DBA

SQL The One

Posted on December 4, 2016 by uday arumilli

SQL The One A Book for SQL Server Interview Preparation Hello there, finally we are presenting the book “SQL The One”. This is the one place guide for SQL Server Interview preparation. The core intention is to help the maximum … Continue reading →

Posted in High Availability, Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , | 35 Comments

SQL Server Blocking Report

Posted on November 25, 2016 by uday arumilli

SQL Server Blocking Report This post can help a SQL DBA / Developer to quickly find the SQL Server Blocking Report using T-SQL scripts. There are various ways to get the SQL Server Blocking Report but here we are going … Continue reading →

Posted in SQL Development, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment

SQL Server Space Usage

Posted on November 17, 2016 by uday arumilli

SQL Server Space Usage Hello there, this post can explain various ways to know the SQL Server Space Usage information. Here are the different ways available: XP_FIXEDDRIVES SP_SPACEUSED SP_HELPDB DBCC SQLPERF (LOGSPACE) sys.dm_os_volume_stats Database and file wise Space usage Used … Continue reading →

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , | Leave a comment