The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.

Storage Size

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005).

RE: Selecting a Web Host for your SQL Server Database Driven Web Site Part

Nice Article Jon!We do web development and db work for clients and have been using a fairly good host - but my gripe with their company is that they have a ton of other db instances on the server along with ours.  This is a concern for obvious reasons.  So I add that when shopping for a host it would […]

RE: Multiple Data Files to increase performance

Yuo can also set the new filegroup as default, thereby cause all new objects to be placed there (unless specified differently in the create statement).

Looking for White Paper or resource on Physical Architecture for partitions and such

Machine HP ML57012 * 143 g hd 3 g ram2 xeon 3.0 prOS W2k RAID 5 Need help with how to determine how I partition the space for a data warehouse? Thanks

RE: Cycling Those Error Logs

Hi Guys, Steve,We have a similar setup, but we also have changed the registry to allow sqlserver to record 7 log entries, so that we also have the last weeks worth of logs, although not necessary in most installations, I just find a week a reasonable threshold. But here's a side note for all you (there […]

RE: Unknown - \\ - MSSQLServer

Hi Stef,We have exactly the same issue on Win2k SP4 + Sql 2k SP3a.  Two instances running on this server, neither is a 'default' instance.  When you look in the Service Manager, nothing !, but if you type in the server\instance name then hit refresh services, voila it appears ok.   Also connecting on the server […]

RE: sql injection articles

Not that we're the most dilligent, but we don't have any real information about anyone on this site (no SSNs, credit cards, etc). Any billing we do for http://www.sqlserverstandard.com is outsourced so we don't hold it. You shipping address goes in another write only table, so it's fairly secure.The user that connects to the db has […]