Subscribe to this blog
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
0 comments, 350 reads
Posted in Vinay Thakur on 28 March 2011
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
0 comments, 130 reads
Posted in Vinay Thakur on 21 March 2011
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
0 comments, 259 reads
Posted in Vinay Thakur on 4 March 2011