Shrink a Database SQL Server 2008 R2

This topic describes how to shrink a database by using Object Explorer in SQL Server Management Studio. The database cannot be made smaller than the minimum size of the database. The minimum size is the size specified when the database was originally created, or the last explicit size set by using a file-size-changing operation, such as DBCC SHRINKFILE. For example, if a database was originally created with a size of 10 MB and grew to 100 MB, the smallest size the database could be reduced to is 10 MB, even if all the data in the database has been deleted.

Shrinking data files recovers space by moving pages of data from the end of the file to unoccupied space closer to the front of the file. When enough free space is created at the end of the file, data pages at end of the file can deallocated and returned to the file system.

To shrink a database

1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand Databases, and then right-click the database that you want to shrink.
3. Point to Tasks, point to Shrink, and then click Database.
4. Optionally, select the Reorganize files before releasing unused space check box. If selected, a value must be specified for Maximum free space in files after shrinking.
   Selecting this option is the same as specifying a target_percent value when executing DBCC SHRINKDATABASE. Clearing this option is the same as executing DBCC SHRINKDATABASE. By default, the option is cleared.
5. Enter the maximum percentage of free space to be left in the database files after the database has been shrunk. Permissible values are between 0 and 99. This option is only available when Reorganize files before releasing unused space is selected.
6. Click OK.
   
   
   
   

   Negative List Updation Patch - Updated upto 31/03/2013

   
   

   This patch file updates the negative list available in Sanchay Post software. To confirm updation, use the "Database Discrepancies >> NSC >> Details of Negative List Updation" option available in DBAnalyzer software.

   
   

   
   

   The file 'NL_20130331.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 31/03/2013  in Sanchay Post.

   
   

   
   

   In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. System Administrators should ensure that the server is not switched off till successful execution of the patch.

   
   

   
   

   Downloadable from FTP site of PTC, Mysore.

   
   

   INDIAN CIVIL SERVICE EXAMINATION - SOME USEFUL INFORMATION

   
   

   Indian Civil Services
   Civil  Service  Examination  2012  result  has  been  announced  First rank  holder  from  Kerala To  see the  list  of  winners Please  click  List
   A  Real  picture  of Civil   Service  Exam  from  2007 to  2011
   Year/Details	2007-08	2008-09	2009-10	2010-11
   Prelims Applied	333680	325433	409110	497187
   Prelims Appeared	161469	167035	193091	NA
   Mains applied	9158	11669	11894	11984
   Interviewed	1883	2136	2281	NA
   Selected	638	791	875	920
   Civil Service Aptitude Test (CSAT) which involves 1 paper on general studies and 1 paper on aptitude test
   Main test which has 9 papers, followed by an interview.
   The Civil Services Exam is conducted for the recruitment of various administrative services of the government including Indian Revenue Service (IRS), Indian Administrative Service (IAS), Indian Foreign Service (IFS), Indian Police Service (IPS) and more.
   must be a minimum of 21 years of age or maximum of 30 years of age on the first august of the year of the examination. The age restrictions on the Civil Services Exams may be relaxed for students from scheduled castes, scheduled tribes, other backward classes, disabled Defence personnel, and a few more.
   Minimum educational qualification  ----------------    must hold a degree from any recognised state, central or deemed university
   If you   would like  to  appear for  civil  service exam   -  please click   Question  Bank     to  get question  paper  for  previous   year  examination  of   Civil  service  exam
   Stage I: Preliminary examination - This is qualifying test held in May/June every year. Notification for this is published in December/January. Results are published in the first half of August. Stage II: Main examination - This is the main test, held in October/November every year. Results are usually published in the second week of March. Stage III: Personality Test (Interview) - It is the final test and is held in April/May every year. Final results are usually announced a few days before the next preliminary examination.
   If you  want to  know  the real  position  of  civil  service  examination  2013  Please  click     CIVIL SERVICE EXAMINATION 2013