KAVALIPOST

Saturday, 4 May 2013

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 
    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

Promotions to the cadre of HSG-II(General Line) in AP Circle

Circle Office Hyderabad, vide memo no ST/5-1(P)/2012 dated 02.05.2013 has ordered the following promotions the cadre of HSG-II(General Line) in the pay band Rs.9300-34,800 with Grade Pay Rs.4,200/- to the following LSG officials with immediate effect and allotted to the regions noted against their names.

Sl no
Name of the Official
Community
PresentWorking
Region to which alloted
1
B.Satyanarayana,APM(LSG), Regd,Dly,Hyderabad GPO
ST
Hyd GPO

Hyderabad
2
NVSN.Raju, PRI(P), Waltair RS HO
OC
VM
Visakapatnam
3
P.Jhansi Laxmi,APM(LSG),SB SOs,HYd GPO
OC
Hyd GPO
Hyderabad
4
B.Narender Raj, PRI(P), Humayun Nagar
OC
Hyd City Dn
Hyderabad
5
M.Rajamallu,PRI(P), Mancherial HO
SC
HR
Hyderabad
6
C.Panduranga Das, APM(Try), HYD GPO
OC
Hyd GPO
Hyderabad
7
R.Shyam sundar Reddy, PRI(P),Karim Nagar Dn
OC
HR
Hyderabad
8
Rama Chandra Naik,PRI(P), Hindupur HO
ST
KNL
Kurnool
9
P.Mohan Rami Reddy , APM(Mails),Chittoor HO

ST
KNL
Visakapatnam
10
R.Ravinder Reddy, APM(Mails),Karimnagar Dn.
OC
HR
Hyderabad
11
K.Roopkala ,APM(LSG) ,Day-II Counter,Hyd GPO
OC
Hyd GPO
Visakapatnam
12
V.Venugopala Rao,APM (Mails), Guntakal HO

OC
Kurnool
Visakapatnam
13
Ch.MuniRaju,PRI(P), Gudivada HO
SC
VJA
Visakapatnam
14
K.Vasudas,Offtg SPM,Maharanipet,Visakapatnam Dn
SC
VM
Visakapatnam



Thursday, 2 May 2013


  INDEFINITE STRIKE IN  KERALA CIRCLE


ENTIRE  POSTAL &  RMS  EMPLOYEES  (NFPE & FNPO) OF CENTRAL REGION KERALA CIRCLE STARTED  INDEFINITE  STRIKE FROM Ist MAY, 2013 AGAINST THE ATROCITIES AND PERVERTED ACTIONS OF SHRI GEORGE NAINAN PMG . STRIKE 100%. ALL POST OFFICES AND RMS OFFICES REMAINED PARALYSED . IF DEMANDS ARE NOT SETTLED BEFORE 5TH MAY, 2013, ENTIRE KERELA CIRCLE WILL GO ON INDEFINITE  STRIKE
INTEREST TABLE W.E.F 01.04.2013


RD Maturity Value for Denomination of Rs.100

Maturity Value before 01.12.2011
Maturity Value w.e.f 01.04.2012 to 31.03.2013
Maturity Value w.e.f 01.04.2013
Interest @ 7.5 %
Interest @ 8.4 %
Interest @ 8.3 %
Rs. 7289/-
Rs. 7465/-
Rs. 7445/-

RD Maturity Value for Denomination of Rs. 100/-
in case of extension after 5 Years

Maturity Period
Interest @ 8.40 %
01.04.2012 to 31.03.2013
Interest @ 8.30% w.e.f 01.04.2013
5 Years
7465
7445
6 Years
9368
9338
7 Years
11436
11392
8 Years
13682
13622
9 Years
16124
16044
10 Years
18777
18672

MIS Monthly Interest for Denomination of Rs.150000/-

Monthly Interest before 01.12.2011
Monthly Interest  w.e.f 01.04.2012 to 01.04.2013
Monthly Interest  w.e.f 01.04.2013
Interest @ 8.0%
Interest @ 8.5%
Interest @ 8.4%
Rs. 1000/-
Rs.1062/-
Rs.1050/-


NSC 5 Year Maturity Value for Denomination of Rs.10000/-

Maturity Value before 01.12.2011
Maturity Value  w.e.f 01.04.2012 to 31.03.2013
Maturity Value  w.e.f 01.04.2013
Interest @ 8.0%
Interest @ 8.6%
Interest @ 8.5 %
Rs. 16010/- (6 Year)
Rs.15235/- (5 Year)
Rs.15162/- (5 Year)


NSC 10 Year Maturity Value for Denomination of Rs.10000/-

Maturity Value  w.e.f 01.04.2012 to 31.03.2013
Maturity Value  w.e.f 01.04.2013
Interest @ 8.9%
Interest @ 8.8%
Rs.23887/-
Rs.23660/-


SCSS Quarterly Interest for Denomination of Rs.100000/-

Interest @ 9.3%
Interest @ 9.2%
Quarterly Interest  w.e.f 01.04.2012 to 31.03.2013
Quarterly Interest  w.e.f 01.04.2013

Rs.2325/-
Rs.2300/-