| Author |
 Topic  |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
pootle_flump
Flowing Fount of Yak Knowledge
United Kingdom
1064 Posts |
 Posted - 07/12/2007 : 18:55:59
|
I considered recommending your script but misread sysfiles as sys.files and thought it was 2005 specific. Also, I don't know if this is 2005 specific, but I believe that shrinkfile is not a single transaction - an abort midway through does not undo page movements. Dunno if that prevents the file actually shrinking though... Thought I would mention as your intro suggests otherwise  |
 |
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 07/13/2007 : 00:22:42
|
heh, i went ahead and posted it for ya. 
elsasoft.org |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 07/13/2007 : 09:42:25
|
quote:
Originally posted by pootle_flump
I considered recommending your script but misread sysfiles as sys.files and thought it was 2005 specific. Also, I don't know if this is 2005 specific, but I believe that shrinkfile is not a single transaction - an abort midway through does not undo page movements. Dunno if that prevents the file actually shrinking though... Thought I would mention as your intro suggests otherwise
The script works with 2000 or 2005. The reason I developed it is to be able to shrink databases with large amounts of free space in small increments.
I originally posted it for a guy who had a 200 GB database with only 80 GB used and was having trouble shrinking it. It's set to shink by just 50 MB at a time, so it takes a while, but it just keeps on going and eventually gets done. Of course, you may want to do some reindexing when finishes.
Sorry for hijacking a thread dedicated to complaining about twits to try to help someone. 
CODO ERGO SUM |
Edited by - Michael Valentine Jones on 07/13/2007 09:57:13 |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/13/2007 : 12:13:48
|
Most probably the answer would be "Integer overflow"!
Thanks, chaps!
Peter Larsson
Helsingborg, Sweden |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 07/13/2007 : 12:42:46
|
quote:
[i]Originally posted by Michael Valentine Jones
Sorry for hijacking a thread dedicated to complaining about twits to try to help someone.
I feel so sheepish now...in any case, I don't think it was ever mentioned that it's not data related
And if space is an issue, why retain another monster on disk that's not being used?
I just don't...But I do like your script
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 07/13/2007 : 13:39:07
|
I started to register at dbforumns, but quit when they asked for my birthday.
I don't see that as any of their business, unless there's some adult content unsuitable for under 18.
CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 07/13/2007 : 14:17:16
|
quote:
Originally posted by Michael Valentine Jones
I started to register at dbforumns, but quit when they asked for my birthday.
I don't see that as any of their business, unless there's some adult content unsuitable for under 18.
CODO ERGO SUM
It's required?
So put in a future date
Or
January 1, 1753
Or Better
December 31, 1752
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 07/13/2007 : 15:32:03
|
I could register as Connor Macleod, born in 1518.
What RDMS does that site run on? MySQL?
CODO ERGO SUM |
Edited by - Michael Valentine Jones on 07/13/2007 15:33:10 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 07/17/2007 : 09:56:47
|
> we don't have backups because of less free space
jesus... that's got to be one crazy company
_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
dinakar
Flowing Fount of Yak Knowledge
USA
2507 Posts |
Posted - 07/19/2007 : 18:41:31
|
quote:
Originally posted by Peso
I really am trying hard on this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86615
Peter Larsson
Helsingborg, Sweden
Most of his posts are like that. I got stuck with him on couple of other posts. I saw you were waging a lone battle. Wanted to help but I figured you have enough xperience here to handle such requests
Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 07/19/2007 : 22:35:41
|
quote:
Originally posted by Peso
I really am trying hard on this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86615
Peter Larsson
Helsingborg, Sweden
Every time he posts an "explanation", it somehow makes the requirements even less clear and he manages to introduce new, unclear requirements.
I think a lot of the people that post here need to master written communications before they take on SQL. It’s really two sides of the same problem; they can’t communicate requirements to people or computers. Fundamentally, they don’t have the requirements clear in their own minds, so it’s impossible to communicate something they don’t understand.
CODO ERGO SUM |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 07/19/2007 : 22:46:44
|
quote:
Originally posted by Peso
I really am trying hard on this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86615
Peter Larsson
Helsingborg, Sweden
With a name like arith - maniac, i stay away from this thread. Ever trying to help a member with name like 'C++' to use set-based operation
KH
Time is always against us
|
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 07/19/2007 : 23:39:58
|
hey, I started with C++!
furthermore, your beloved SQL Server is built with C++.
elsasoft.org |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
Topic |
|
Twit List
