Author |
Topic |
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-19 : 16:10:11
|
This title cracked me up:My boss who knows nothing about database design, but likes excel will probably love it though.I cant wait to export INFORMATION_SCHEMA views to excel, I am sure it will make my life a lot easier Quote from the article:quote: "While a certain amount of discipline is required to keep these worksheets up to date, the utility will allow you to begin improving your database housekeeping"
rockmoose |
|
X002548
Not Just a Number
15586 Posts |
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-19 : 16:51:42
|
funny indeed ! -------------------------------------------------------------------------------We have this really cool app that imports the metadata,AND generates and RUNS the necessary DDL statements to make the database compliantwith the NEW metadata specifications.The only thing is that it is a bit SLOW when there is alot of data in the tables.Do You think that if I used XML, it would make it faster ?rockmoose |
|
|
jhermiz
3564 Posts |
Posted - 2005-01-19 : 19:40:58
|
The germans love excel they call it the daaaaaaaaaatabase here. Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-19 : 21:05:59
|
http://neopoleon.com/blog/posts/434.aspxWho has seen one of these meetings taking place ?/raises hand solemnlyDamian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-19 : 21:12:52
|
Interviewer: Have you used any database design toolsInterviewee: Yes, Excel==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-20 : 01:32:19
|
"Do You think that if I used XML, it would make it faster ?"No, but it will be n-tier Kristen |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-20 : 01:50:22
|
quote: Originally posted by Merkin http://neopoleon.com/blog/posts/434.aspxWho has seen one of these meetings taking place ?/raises hand solemnlyDamian
that guy is really artistic, liked his drawings, very expressive.atleast the marketing group learned from previous experience and they're pretty good at brainstorming noh? LOL--------------------keeping it simple... |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-01-20 : 03:03:06
|
One of my favourites is when we were given excel sheets to import into our dw system.And they used color coding to distinguish the data "#¤!"#¤!!DTS doesn't do that Yet!Maybe I should put it on my wishlist to m$ rockmoose |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-01-25 : 06:41:01
|
Merkin, that link is brilliantsteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
|
|
|