Tag Archives: sql server

SQL Server Space Usage

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

Preparing for SQL DBA Interview

Preparing for SQL DBA Interview This article list out few tips on “Preparing for SQL DBA Interview” If you are reading this article which means you must be a Database Administrator/professional or getting ready for entering into DBA world. In … Continue reading

Posted in Interview Q&A, Miscellaneous, SQL Server DBA | Tagged , , , , , | 14 Comments

Update Without Where Clause

Update Without Where Clause Running Update Without Where Clause might causes a data damage when it is with the critical table that creates a lot of problems and escalations. Recently while working with one of the customer we had a … Continue reading

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