The Database Design Resource Center

What is SQL. Let's Google it.

by mark
(Netherlands)

First of all. I like al the articles.

My story is one that is still happening today.

I started my career at a Dutch company as a System Administrator.
At first there were only two "developers".

The developers weren't developers at all but were two people who worked at the warehouse of this company and start to make promotion after promotion.
When I arrived, i did not know that these people had no programming background at all so i just let them build applications after applications.

When i started to work there, they just baught some new servers. Including a MS SQL 2000 server.

The two developers then started to make databases, tables etc.
But they did not know anything about SQL. (they googled SQL to find out what it was)

The model they designed did not have any relations, no indexes etc.
It was just a bunch of flat tables.
After the first customer used the "database", everything just crashed.
With a few tweaks the server started to perform a bit.
But after 2 months the server stopt working.
We did not have any knowlegde of SQL performance tuning at the time so we bought a new server.

At this time were still running with this model for most of our customers.
We have about 8 SQL servers right now and still have huge performance issues.

Because we cant change the model because we can not alter the programs (all logic is build in DTS packages and jobs), were stuck at the moment.

The only difference is that i am a DBA with much more knowledge.
Were developing a datamodel that is properly normalized and indexed.
But it is still one year away from being complete.
So my 90% of my job right now is to keep the servers running.



Comments for What is SQL. Let's Google it.

Average Rating starstarstarstarstar

Click here to add your own comments

Nov 11, 2015
Rating
starstarstarstar
Google NEW
by: Riley

Blog posts are definitely my source of entertainment and you have amazed me with your writing. Keep up the good work and I hope to see more blog post on the website. celebsclothing.com

Nov 09, 2015
Rating
starstarstarstar
SQL NEW
by: Johnson

Impressed! It’s been a long time that I got interest to read what others write to have useful information that I further discuss among my gathering and it makes our time good. We make cross questions and answer them but for all that I read articles and this site has been on top of my list for providing such information. Site

Aug 06, 2015
Rating
starstarstarstarstar
Good post NEW
by: Cecile Lockman

Hello! Your site is great!
How much time did you spend to write so awesome articles?
I want to suggest you to advertise my site Clothes4Dance on your blog, is it possible?
I really love your site and your audience, I will pay any money to publish a guest post, for example, on your site.
Please, answer me! Thank you!

Jul 15, 2015
Rating
starstarstarstarstar
Education NEW
by: Anonymous

Educated people know the after effects of anything they control their actions according to the best-dissertation.org writing service. They never indulge themselves in any evil task. They support and promote good things because they know that evilness can destroy peace.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Worst Database Design Experience.


Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant


Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:


What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:


Database Normalization eBook



Copyright © www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.