To find size of all databases in sql server this query is very useful Download the script here SELECT d.name, d.create_date, d.database_id, ROUND(SUM(mf.size) * 8 / 1024, 0)
This article describes SQL Server database file Groups. When we create a new database, then the Server database contains default file Groups. They are called primary files Groups.
The most effective method to Create Cubes, Dimensions and Measures in SQL Server Business Intelligence What is the utilization of information in the event that it is not
Intoduction Today I will explain to you how to Install SQL Server Without Rebooting. When I understood that I required it SQL Server Management Studio to investigate my
NOTE: The following post is based on Lync Server 2013 Preview. Procedures and screenshots are subject to change when Lync Server 2013 is RTM. I described how to
This blog defines how to set password of SQL Server after installation. Many times we installed SQL Server on window authentication mode and after that we need to
In this tutorial we will fetch data from SQL Server database using LINQ and display that data in Silverlight, while we are following ASP.Net MVC Framework. Step 1: Create