Tag Archives: sql server

TSQL script to get the index size and information in SQL Server

TSQL script to get the index size and information in SQL Server TSQL script to get the index size and information in SQL Server post can help you in getting the index information from a database in SQL Server. There … Continue reading

Posted in Performance Tuning, SQL Development | Tagged , , , , , , , , , , , | Leave a comment

Top 10 SQL Server Architecture Interview Questions

Top 10 SQL Server Architecture Interview Questions SQL THE ONE There are total 46 questions are answered under SQL Server Architecture category in the book “SQL THE ONE”. In this chapter we’ll find interview questions and answers on SQL Server … Continue reading

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

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