Technical Blog

Asp.net, C#, VB.net, MS SQL, ADO.net

Menu

Skip to content
  • Home
  • RPA
  • Asp.net
  • OOP
  • C#
  • VB.Net
  • MS SQL Server
  • Coding Standard
  • XML
  • Contact us

Month: June 2016

June 28, 2016 by admin

sql server find the size of all drives in database server

I was curious about, is there any way to get the size of all drives of a server using sql query. I found one as follows.

EXEC master..xp_fixeddrives

Share this:
Share
Posted in MS SQL Server, T-SQL | Leave a comment
June 28, 2016 by admin

sql server find the size of database file find the size of log file

Today I got a concern from my colleague, how to find the size of database file using sql query. Here is query, you can alter this query according to your need.

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = ‘master’
GO

Share this:
Share
Posted in MS SQL Server, T-SQL | Leave a comment
Indian Design Services

Post Category

  • Agile (3)
  • Asp.net (10)
  • C# (13)
  • Coding Standard (1)
  • Javascript (1)
  • MS SQL Server (19)
  • OOP (6)
  • RPA (2)
  • T-SQL (2)
  • VB.Net (10)
  • XML (3)

Archives

  • April 2018
  • November 2016
  • June 2016
  • April 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015

Tag Cloud

Abstract class Agile Methodology appSettings Boxing Coding Standard Comparison Operators ConnectionStrings Constructor C Sharp Delegate Deserialization Dynamic Polymorphism Full Join ICollection IEnumerable interface Javascript Join Left Join Logical Operators Method Hiding Method Overloading Method Overriding MS SQL Multicast Delegate Naming Conventions OOP Polymorphism Querystring Readonly variable Right Join Row_Number Runtime Polymorphism Serialization Single Cast Delegate Static Polymorphism T-SQL UI Control Unboxing VB.Net Virtual Method Waterfall Methodology Web.config XMLSerialization XmlSerialzer
Share
© 2008-2023 Indian Design Services
error: Content is protected !!
Contact Us On WhatsApp