| Author |
 Topic  |
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
 Posted - 07/23/2010 : 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
USA
4964 Posts |
Posted - 07/23/2010 : 12:25:13
|
| Wow, some pretty impressive numbers in there. |
Edited by - russell on 07/23/2010 12:26:00 |
 |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/23/2010 : 13:28:40
|
How do you view the unzipped xml-powerpoint presentation?
N 56°04'39.26"
E 12°55'05.63" |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/23/2010 : 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? |
|
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 07/23/2010 : 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. |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/23/2010 : 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? |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/23/2010 : 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 ... |
|
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 07/23/2010 : 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. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 07/23/2010 : 14:33:47
|
Yet another reason not to use IE: it won't even download Microsoft's own file formats properly.    |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/23/2010 : 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. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 07/23/2010 : 15:04:57
|
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 |
|
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 07/23/2010 : 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. |
|
|
|
russell
Pyro-ma-ni-yak
USA
4964 Posts |
Posted - 07/23/2010 : 16:05:07
|
| Worked fine for me using IE |
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8513 Posts |
Posted - 07/24/2010 : 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. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
So you think you've got a big database?
