Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Read more

0 comments, 463 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

Read more

0 comments, 193 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

Read more

0 comments, 449 reads

Posted in Vinay Thakur on 4 March 2011