SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Twit List
 New Topic  Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 88

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/12/2007 :  13:36:20  Show Profile  Reply with Quote
quote:
Originally posted by X002548

Thanks for the useless advice, but I don't have any too offer

http://www.dbforums.com/showthread.php?t=1620053



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



I would suggest he use this script, but I don't feel like registering over there. It does require him to figure out the name of the file he wants to shrink, but there is a query in the script to show the free space for each file.

Shrink DB File by Increment to Target Free Space
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80355






CODO ERGO SUM
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 07/12/2007 :  18:55:59  Show Profile  Reply with Quote
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
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2885 Posts

Posted - 07/13/2007 :  00:22:42  Show Profile  Visit jezemine's Homepage  Reply with Quote
heh, i went ahead and posted it for ya.


elsasoft.org
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/13/2007 :  09:42:25  Show Profile  Reply with Quote
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
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 07/13/2007 :  10:15:47  Show Profile  Reply with Quote
How about a script that shows how many of Peter's posts are in reply to funketekun?

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30112 Posts

Posted - 07/13/2007 :  12:13:48  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Most probably the answer would be "Integer overflow"!

Thanks, chaps!


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 07/13/2007 :  12:42:46  Show Profile  Reply with Quote
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



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/13/2007 :  13:39:07  Show Profile  Reply with Quote
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
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 07/13/2007 :  14:17:16  Show Profile  Reply with Quote
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



Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/13/2007 :  15:32:03  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30112 Posts

Posted - 07/16/2007 :  14:36:35  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Please help me
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86437


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 07/16/2007 :  14:59:32  Show Profile  Visit spirit1's Homepage  Reply with Quote
helped

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 07/17/2007 :  09:40:30  Show Profile  Reply with Quote
It just keeps getting better

http://www.dbforums.com/showthread.php?t=1620053&page=5



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



Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 07/17/2007 :  09:56:47  Show Profile  Visit spirit1's Homepage  Reply with Quote
> 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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30112 Posts

Posted - 07/19/2007 :  18:31:34  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I really am trying hard on this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86615


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 07/19/2007 :  18:41:31  Show Profile  Visit dinakar's Homepage  Reply with Quote
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/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 07/19/2007 :  22:35:41  Show Profile  Reply with Quote
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
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17584 Posts

Posted - 07/19/2007 :  22:46:44  Show Profile  Reply with Quote
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

Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2885 Posts

Posted - 07/19/2007 :  23:39:58  Show Profile  Visit jezemine's Homepage  Reply with Quote
hey, I started with C++!

furthermore, your beloved SQL Server is built with C++.




elsasoft.org
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36601 Posts

Posted - 07/22/2007 :  14:03:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
A DBA who doesn't know what his/her job entails: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86542

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
Page: of 88 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000