Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 So you think you've got a big database?

Author  Topic 

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-23 : 09:41:05
http://bit.ly/aNg6lZ

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

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-23 : 12:25:13
Wow, some pretty impressive numbers in there.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-23 : 12:56:11
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

30421 Posts

Posted - 2010-07-23 : 13:28:40
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

38200 Posts

Posted - 2010-07-23 : 14:05:08
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

22859 Posts

Posted - 2010-07-23 : 14:10:30
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

15732 Posts

Posted - 2010-07-23 : 14:11:22
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

22859 Posts

Posted - 2010-07-23 : 14:16:46
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

22859 Posts

Posted - 2010-07-23 : 14:19:52
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

15732 Posts

Posted - 2010-07-23 : 14:27:39
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

38200 Posts

Posted - 2010-07-23 : 14:29:03
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

15732 Posts

Posted - 2010-07-23 : 14:33:47
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

38200 Posts

Posted - 2010-07-23 : 14:38:29
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

22859 Posts

Posted - 2010-07-23 : 14:39:18
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

30421 Posts

Posted - 2010-07-23 : 15:04:57
Thank you. Renaming extension from zip to pptx worked great!


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

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-23 : 15:18:29
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

5072 Posts

Posted - 2010-07-23 : 16:05:07
Worked fine for me using IE
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-24 : 07:53:49
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

38200 Posts

Posted - 2010-07-24 : 15:22:19
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
   

- Advertisement -