On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and ...
I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring. However, this only gives me an absolute ...
I'm curious about effective space allocation of my tables, so: does something like SqlYog exist for SQL Server 2005 (and later)? Of course I know SSMS, but I was looking for something more precise ...
Is there a way to calculate the physical drive space required for a full-text search catalog? Space is cheap, but I'd like to know what I'm getting into. I'm looking at a table of about 200 articles ...
Scenario: SQL Server 2005 database servicing an ASP.NET application (on a separate web servers). Database: DB has about 5GB of "normal" data in it, and about 15GB of "files" (e.g.: a 200k PDF stored ...