Monthly Archives: March 2011

Torn page detection vs Page Checksum

TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The data page is of size 8k and  combination of 8 pages is called extent. where as hardware storage is stored in … Continue reading

Posted in Basic, Computers and Internet, What I learned today | Tagged , , | 2 Comments

Diskpart command line utility

To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information. some good commands are. diskpart diskpart> list disk diskpart> select disk <0> diskpart> detail disk some more commands…. http://support.microsoft.com/kb/300415 Must … Continue reading

Posted in Computers and Internet, General, Software, What I learned today | Tagged , | Leave a comment

Resource database

Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server 2005, this database is hidden and user cannot see and access it directly, all the sys. schema (system objects) are … Continue reading

Posted in Computers and Internet, General, Limitation, What I learned today | Tagged , | Leave a comment