KRISHNA SQL EXPRESS

Saturday, February 12, 2011

Shrink VS Truncate + SQL Server


Shrink VS Truncate + SQL Server


FAQ: Difference between shrink and truncate?

o    Truncate cannot remove empty space

o    Shrink can remove empty space, so space can recollect

Posted by KrishnaReddy Pelleti at 7:51 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (23)
    • ►  05/12 - 05/19 (8)
    • ►  04/21 - 04/28 (8)
    • ►  04/14 - 04/21 (7)
  • ►  2012 (5)
    • ►  12/09 - 12/16 (1)
    • ►  12/02 - 12/09 (4)
  • ▼  2011 (33)
    • ►  05/15 - 05/22 (4)
    • ►  05/01 - 05/08 (2)
    • ►  02/13 - 02/20 (13)
    • ▼  02/06 - 02/13 (14)
      • Killing all Sql Server Data Bases
      • SQL DBA interview questions+ CSC
      • Security in SQL Server 2005 VS SQL Server 2000
      • SQL DBA interview questions+ IBM
      • SQL DBA interview questions+ HCL + 2nd round
      • SQL DBA interview questions+ Infosys
      • SQL DBA interview questions+ HCL
      • Shrink VS Truncate + SQL Server
      • SQL Server Interview Questions + CTS
      • Moving System DB’s in SQL Server
      • SQL DBA interview questions+ Wipro
      • SQL DBA Interview Questions + Congnizant
      • SQL DBA interview questions+ TCS
      • Sql Server Migration Assistent
Awesome Inc. theme. Powered by Blogger.