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
 Excell Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JimL
SQL Slinging Yak Ranger

USA
1535 Posts

Posted - 05/06/2005 :  11:29:35  Show Profile  Visit JimL's Homepage  Reply with Quote
Warning...Warning Will Robinson.

Imminent Rant Detected.

“I have my data stored in the database, its right here on this excel spread sheet."

I would like to choke all the instructors that refer to excel as a database.

I cannot believe the number of times I have had to explain this to people.


Then there is the second part "Well I can do it on my spread sheet!"



Jim
Users <> Logic

X002548
Not Just a Number

15586 Posts

Posted - 05/06/2005 :  12:12:50  Show Profile  Reply with Quote
Hey, there are somethings that Excel, well , excels at.

Like Access (or any other tool for that matter) it can be well abused.

For example, another consultant built this monster...34 tabs, over 20,000 formulas ( I know because I wrote som vb to extract all the formulas, with their tab and cell refernce to a delimted file. So I could load it to a table and do some analysis..they needed help to dociment what they built because of SOX....what a mess...

My pet peeve..that the call Notus Lotes a database...I hate notes...



Brett

8-)
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 05/06/2005 :  12:25:24  Show Profile  Reply with Quote
Excel as a database

I know I posted that before, but it so funny

rockmoose
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1535 Posts

Posted - 05/06/2005 :  12:48:34  Show Profile  Visit JimL's Homepage  Reply with Quote
I have begun to use the example of

I can create a million dollar paycheck using illustrator,
But I doubt the bank will cash it.


Jim
Users <> Logic
Go to Top of Page

mfemenel
Professor Frink

USA
1421 Posts

Posted - 05/06/2005 :  14:07:27  Show Profile  Visit mfemenel's Homepage  Reply with Quote
I swear whenever we are starting with a new group when they say "we keep our data in an access database" a certain part of me puckers very very tightly. I almost prefer the ones who use excel because they don't think they know databases(usuaully). Try convincing someone who only knows access that it's not the best thing in the world and watch the sparks fly.

Mike
"oh, that monkey is going to pay"
Go to Top of Page

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 05/06/2005 :  14:22:15  Show Profile  Visit jhermiz's Homepage  Reply with Quote
BAHAHAHAHAHAHAHAHAHAH

moose that really was funny, (wiping tears right now).

You guys think that is bad...I have worked with this german company for about 4 years and they have been using this ENORMOUS (sounds like brett's app) 50+ tab excel workbook ironically called, the kalculation database. This thing has been nothing but a nightmare from the get go. And each day a new tab is added and 50 new macros....talk about denormalized...

If anyone wants any tips of how to denormalize a database then come work with us!!!! We'll even put it in the EXCEL database!!!!!!




Keeping the web experience alive -- http://www.web-impulse.com
Imperfection living for perfection --
http://jhermiz.blogspot.com/
Go to Top of Page

mfemenel
Professor Frink

USA
1421 Posts

Posted - 05/06/2005 :  14:25:28  Show Profile  Visit mfemenel's Homepage  Reply with Quote
See that's why I like SQL Team. Whenever I think I work with stupid people, there's always someone who has it worse and I can move on. Sounds like a piece of krap.

Mike
"oh, that monkey is going to pay"
Go to Top of Page

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 05/06/2005 :  14:29:48  Show Profile  Visit jhermiz's Homepage  Reply with Quote
They aren't stupid, remember we are always considered the peons.

Its always your fault, even if you are right.


Keeping the web experience alive -- http://www.web-impulse.com
Imperfection living for perfection --
http://jhermiz.blogspot.com/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/06/2005 :  14:47:21  Show Profile  Reply with Quote
Our customers receive data from us, and almost always want it in Excel.

We have one customer that gets a daily one with 150 tabs on it that is about 45 MB in size. It has extensive formatting on each tab, as required by the customer, and no one can figure out why it takes 10-15 hours to create.

They asked me if it was a SQL Server issue, and I showed them that I could run all the queries required in about 15 minutes. I think they don't really believe me, and suspect some DBA trickery.







CODO ERGO SUM
Go to Top of Page

jhermiz
Flowing Fount of Yak Knowledge

USA
3564 Posts

Posted - 05/06/2005 :  14:48:47  Show Profile  Visit jhermiz's Homepage  Reply with Quote
Ahh yes, memories, again its your fault..they prolly look at you like you are lying...


Keeping the web experience alive -- http://www.web-impulse.com
Imperfection living for perfection --
http://jhermiz.blogspot.com/
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 05/06/2005 :  17:30:30  Show Profile  Reply with Quote
They may suspect I'm lying, but they know better than to say it.

My retaliation would be swift and unmerciful.


quote:
Originally posted by jhermiz
Ahh yes, memories, again its your fault..they prolly look at you like you are lying...



CODO ERGO SUM
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.09 seconds. Powered By: Snitz Forums 2000