Welcome to MSDN Blogs Sign in | Join | Help

August 2005 - Posts

Wednesday, August 24, 2005 9:39 PM

[sql 2005] Q: How do we verify page checksum in a database to make sure I have no hardware problem?

DBCC CHECKDB will do just what you want. The PHYSICAL_ONLY option is probably the fastest way to get the checksums validated.
Posted by weix | 0 Comments
Wednesday, August 24, 2005 9:35 PM

[SQL 2005] Q: How to find out how much space is used in database ?

Somebody asked me this question. So here it is: SQL 2005 still supports the following three ways to report data and log space usage for a database: DBCC SQLPERF ( LOGSPACE ) can tell you the log size and used size. sp_spaceused for space used/reserved
Posted by weix | 2 Comments
Tuesday, August 16, 2005 11:48 AM

SQL2005 CLR: two white papers

DBA focus: http://www.sqlskills.com/resources/Whitepapers/SQL%20Server%20DBA%20Guide%20to%20SQLCLR.htm Developer focus: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
Posted by weix | 0 Comments
Sunday, August 14, 2005 11:48 PM

SkyServer based on SQL Server

This is a quite old paper (Jan 02): http://research.microsoft.com/~gray/Papers/MSR_TR_O2_01_20_queries.pdf I was reading some news on astronomy which mentioned the SDSS. So I looked up this paper for some more detail. I thought you might like the way
Posted by weix | 0 Comments
 
Page view tracker