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
 So you think you've got a big database?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 07/23/2010 :  09:41:05  Show Profile  Visit robvolk's Homepage  Reply with Quote
http://bit.ly/aNg6lZ

Be sure to read the notes too, they have some crazy details in them.

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/23/2010 :  12:25:13  Show Profile  Visit russell's Homepage  Reply with Quote
Wow, some pretty impressive numbers in there.

Edited by - russell on 07/23/2010 12:26:00
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/23/2010 :  12:56:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
Wow!

Some of the info may be misleading though. MySpace doesn't store everything in one database. In fact, they said that their largest OLTP database is 60GB. I attended a local user group meeting last year, and the data architect from MySpace presented. She said that everything gets broken up into smaller units and spread across hundreds of servers.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29909 Posts

Posted - 07/23/2010 :  13:28:40  Show Profile  Visit SwePeso's Homepage  Reply with Quote
How do you view the unzipped xml-powerpoint presentation?



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/23/2010 :  14:05:08  Show Profile  Visit tkizer's Homepage  Reply with Quote
It opened up directly into PowerPoint for me.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/23/2010 :  14:10:30  Show Profile  Reply with Quote
You need Office 2007 or later, or you need to install the .aaaX file-extension backward compatibility plugin for Office 2003 or earlier (dunno how much earlier it is supported)

Or I/someone can open and Save-As the version you have and Email you if you like?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 07/23/2010 :  14:11:22  Show Profile  Visit robvolk's Homepage  Reply with Quote
Change the extension from .ZIP to .PPTX, or add .PPTX if there's no extension. It will open in Powerpoint 2007 or 2010.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/23/2010 :  14:16:46  Show Profile  Reply with Quote
The file that downloaded here, from the link on the page, was already .pptX ... is the ZIP file something different? or a side effect of something or other?
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/23/2010 :  14:19:52  Show Profile  Reply with Quote
I liked the slide about the astronomers who are adding 5TB a day to their database and have no DB backup, and tried to put 100TB in a single database file but that exceed some limit in SQL Server ... and they won't upsize because they want to use "small" x64 machines. Cheapskates!

They'll be here any-day now saying "How do I recover my 1PB database, I don't have a backup"

They have backups of the input files, but I figure recreating a 1PB database from Input files is going to take a day or two ...
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 07/23/2010 :  14:27:39  Show Profile  Visit robvolk's Homepage  Reply with Quote
quote:
Originally posted by Kristen

The file that downloaded here, from the link on the page, was already .pptX ... is the ZIP file something different? or a side effect of something or other?

Someone else mentioned they got it as a zip file and when they opened it they saw XML files. Could be a function of the browser used to download it. I used Chrome and had no problems.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/23/2010 :  14:29:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
I used Chrome as well and had no issues. I've also got Office 2007.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 07/23/2010 :  14:33:47  Show Profile  Visit robvolk's Homepage  Reply with Quote
Yet another reason not to use IE: it won't even download Microsoft's own file formats properly.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/23/2010 :  14:38:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
IE is a joke. I only use it when I absolutely have to, like when a site forces me to such as the games over at zone.msn.com.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 07/23/2010 :  14:39:18  Show Profile  Reply with Quote
Hahahah ... spot on. I was using Chrome too ... re-downloaded it in IE and it did indeed treat it as a ZIP file.

Used "Save target as" instead and saved as a PPTX file and it opened fine.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29909 Posts

Posted - 07/23/2010 :  15:04:57  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Thank you. Renaming extension from zip to pptx worked great!


N 56°04'39.26"
E 12°55'05.63"

Edited by - SwePeso on 07/23/2010 15:25:17
Go to Top of Page

robvolk
Most Valuable Yak

USA
15635 Posts

Posted - 07/23/2010 :  15:18:29  Show Profile  Visit robvolk's Homepage  Reply with Quote
quote:
They'll be here any-day now saying "How do I recover my 1PB database, I don't have a backup"
Imagine if it was a 1 PB log file, and they never took a backup.

Makes me wonder if you had all the database transactions from the moment it was created in the log, and lost the MDF, could you create a blank DB and attach the LDF to it, or use one of the 3rd party tools to play it all back. Especially something that large.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 07/23/2010 :  16:05:07  Show Profile  Visit russell's Homepage  Reply with Quote
Worked fine for me using IE
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8679 Posts

Posted - 07/24/2010 :  07:53:49  Show Profile  Visit webfred's Homepage  Reply with Quote
quote:
Originally posted by tkizer

Wow!

Some of the info may be misleading though. MySpace doesn't store everything in one database. In fact, they said that their largest OLTP database is 60GB. I attended a local user group meeting last year, and the data architect from MySpace presented. She said that everything gets broken up into smaller units and spread across hundreds of servers.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog


Yes - 500+ servers and each days adding a server. It is written inside the pptx presentation.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35934 Posts

Posted - 07/24/2010 :  15:22:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
Right but my point is about their data size.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.12 seconds. Powered By: Snitz Forums 2000