Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
SQL General
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
301
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
259
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Shrinking an SQL Database
aka_USAPA
Member
Posts:
62
2007-02-21
edited 2007-03-01
in
SQL General
What are the ramifications of shrinking an SQL database?
Another way:
http://yourfuture.myshaklee.com
0
Comments
Waldo
Member
Posts:
3,412
2007-02-21
Ramifications?
There are no consequences as far as I know ... . The only thing I can think of is the fact that the database has to "autogrow" more, and that could have an impact on performance.
Eric Wauters
MVP
- Microsoft Dynamics NAV
My
blog
0
nunomaia
Member
Posts:
1,153
2007-02-21
Every time SQL has to grow performance is decreased during the increase. So shrink SQL when DB log file had increased to an abnormal size.
Nuno Maia
Freelance Dynamics AX
Blog :
http://axnmaia.wordpress.com/
0
kriki
Member, Moderator
Posts:
9,112
2007-02-22
If it is a test DB, you can do it because, in general, it is better a small DB than a fast DB.
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
0
Administrator
Member, Moderator, Administrator
Posts:
2,500
2007-03-01
[Topic moved from Navision to SQL General forum]
0
Sign In
or
Register
to comment.
Comments
There are no consequences as far as I know ... . The only thing I can think of is the fact that the database has to "autogrow" more, and that could have an impact on performance.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!