April 18, 2011 at 7:58 am
ALZDBA (4/18/2011)
Stefan Krzywicki (4/18/2011)
ALZDBA (4/18/2011)
Does Zip still have the 4GB limit ? :ermm:I used the open source :blush: 7zip free solution. ( I don't know if RAR is actually free)
It is able to compress to split files of a given number of MB/compress file as well as password protection.
and IMO it has a small footprint.
Nope. Zip 14.5 can zip up to 16 exabytes.
in another reply ...
So how is it for scheduling automatic jobs? The built-in zip is very limited, that's why we got the full version.
So it must be the limited version I know off. 😉
16 exabytes will do ... for the moment :hehe:
The 4 gig limit went away in version 9 or 10 I think.
I'm sure the 128 bit version of Zip will be able to handle more. : -)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 18, 2011 at 10:29 am
GilaMonster (4/18/2011)
Cross posting Jeff? 🙂Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords. There's far more.
Whether you get higher compression with RAR or with ZIP depends on what you are compressing. ZIP allowed archives to be split into multiple files back in the days of floppy discs, are you saying that's been removed. It certainly has encryption and passwords.
The RAR util can open all sorts of archives, from iso files, rar and zip, tar.gz, tonnes of others.
If I had to suggest one tool that people get for compressed files, it would be rar, not zip. The build-in zip (in later versions of Windows) is very limited.
Yes, the windows built-in ZIP is indeed very limited. And in recent times RAR has improved to the extent that it's more useful than a full blown ZIP; a few years ago I'd have said ZIP was the better bet, but now it'scertainly RAR.
Tom
April 18, 2011 at 11:04 am
Tom.Thomson (4/18/2011)
GilaMonster (4/18/2011)
Cross posting Jeff? 🙂Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords. There's far more.
Whether you get higher compression with RAR or with ZIP depends on what you are compressing. ZIP allowed archives to be split into multiple files back in the days of floppy discs, are you saying that's been removed. It certainly has encryption and passwords.
The RAR util can open all sorts of archives, from iso files, rar and zip, tar.gz, tonnes of others.
If I had to suggest one tool that people get for compressed files, it would be rar, not zip. The build-in zip (in later versions of Windows) is very limited.
Yes, the windows built-in ZIP is indeed very limited. And in recent times RAR has improved to the extent that it's more useful than a full blown ZIP; a few years ago I'd have said ZIP was the better bet, but now it'scertainly RAR.
It can still split archives into multiple files.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 18, 2011 at 12:46 pm
For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post, I'd appreciate it: http://www.sqlservercentral.com/Forums/Topic1095228-61-1.aspx
Yes, I know I'm in the wrong forum. That's kind of on purpose. I tried a 'right' forum and felt like a tether ball.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 18, 2011 at 12:50 pm
Craig Farrell (4/18/2011)
For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post, I'd appreciate it: http://www.sqlservercentral.com/Forums/Topic1095228-61-1.aspxYes, I know I'm in the wrong forum. That's kind of on purpose. I tried a 'right' forum and felt like a tether ball.
Did they bring you a nice salmon?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2011 at 1:02 pm
CirquedeSQLeil (4/18/2011)
Craig Farrell (4/18/2011)
For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post, I'd appreciate it: http://www.sqlservercentral.com/Forums/Topic1095228-61-1.aspxYes, I know I'm in the wrong forum. That's kind of on purpose. I tried a 'right' forum and felt like a tether ball.
Did they bring you a nice salmon?
hahaha...you mean a 'delicious bass'.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 18, 2011 at 1:11 pm
London's calling....
(and my bank account is crying)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 1:15 pm
CirquedeSQLeil (4/18/2011)
Craig Farrell (4/18/2011)
For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post, I'd appreciate it: http://www.sqlservercentral.com/Forums/Topic1095228-61-1.aspxYes, I know I'm in the wrong forum. That's kind of on purpose. I tried a 'right' forum and felt like a tether ball.
Did they bring you a nice salmon?
With a side of pork chops.
Me: Excuse, me what's 2+2 and how can I get to 10 like that?
A: Well, first you take the derivative of warp using Malcom's theory of Detecting BullshitArtistry while multiplying with a split infinitive.
Me: Uhm, WTF?
Positive side note however: it is making me aware again of when I start flying over people's heads here, so there was value to my playing tether-ball.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 18, 2011 at 1:37 pm
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2011 at 1:39 pm
SQLDCH (4/18/2011)
CirquedeSQLeil (4/18/2011)
Craig Farrell (4/18/2011)
For anyone here who regularly works on the web app/public and private content coding side of things, if you wouldn't mind taking a breeze by this post, I'd appreciate it: http://www.sqlservercentral.com/Forums/Topic1095228-61-1.aspxYes, I know I'm in the wrong forum. That's kind of on purpose. I tried a 'right' forum and felt like a tether ball.
Did they bring you a nice salmon?
hahaha...you mean a 'delicious bass'.
Yeah - that would be it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2011 at 1:42 pm
Brandie Tarvin (4/18/2011)
WayneS (4/17/2011)
@#$%^Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot" in this is that this should give me several hours to work on reading the SQL 2008 Internals book...)
Ouch. Are you allergic to bug bites or was this just an extremely nasty bug?
Well, yes. I'm overly sensitive to them (normal mosquito bites look like a welt), but I think that was a spider bite. I'm actually able to close my hand now, so the meds are definitely helping out.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 18, 2011 at 1:43 pm
CirquedeSQLeil (4/18/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Yup. Booked flights so that I get 4 and a bit days at leisure in the UK after the course. Haven't yet decided where I'll go.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 1:44 pm
WayneS (4/18/2011)
Brandie Tarvin (4/18/2011)
WayneS (4/17/2011)
@#$%^Had a $%^& bug bite my hand while grabbing hay for the horses... now it's all swollen and I'm off to see the doctor.
(The "bright spot" in this is that this should give me several hours to work on reading the SQL 2008 Internals book...)
Ouch. Are you allergic to bug bites or was this just an extremely nasty bug?
Well, yes. I'm overly sensitive to them (normal mosquito bites look like a welt), but I think that was a spider bite. I'm actually able to close my hand now, so the meds are definitely helping out.
Glad to hear it. That the meds are helping, that is. I was thinking we might not find out what happened if your hand injury made it difficult to type.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 18, 2011 at 1:45 pm
WayneS (4/18/2011)
Well, yes. I'm overly sensitive to them (normal mosquito bites look like a welt), but I think that was a spider bite. I'm actually able to close my hand now, so the meds are definitely helping out.
Ouch. I had a spider bite once when I was a kid. My hand was swollen for a week. And we don't have poisonous spiders in my country... Go figure. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 18, 2011 at 1:51 pm
GilaMonster (4/18/2011)
CirquedeSQLeil (4/18/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Yup. Booked flights so that I get 4 and a bit days at leisure in the UK after the course. Haven't yet decided where I'll go.
Oh man, they couldn't do it in July. I'll be over there from the 11th to the 22nd.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 25,801 through 25,815 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply