|
|
-
|
|
A very quick way to find the free space in each file group within your SQL Server database is given below.
SELECT
b.groupname AS 'File Group',
Name,
[Filename],
CONVERT (Decimal(15,2),ROUND(a.Size/128.000,2))
[Currently Allocated Space (MB)],
CONVERT (Decimal(15,2),
ROUND(FI......
|
|
-
|
|
If your corporate environment is monitored by System Center Operations Manager 2007 then here is the update to download the Monitoring Management Pack. This pack of SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 20......
|
|
-
|
|
When you need to troubleshoot a problem, prior to
SQL Server 2005 you have to depend upon PROFILER or query system tables
constantly or some other means to trace the system usage.
SQL Server 2005 onwards DBAs are equipped with
Dynamic Management Views (and Data Mining Extenstions DMX for A......
|
|
-
|
|
In continuation to the SQL2K8R2 Service Pack1 post I got few emails asking why there are 2 additional files (SQLManagementStudio_x64_ENU.exe & SQLManagementStudio_x86_ENU.exe) included in the SP1 download page. ....read more..........
|
|