| Author |
Topic |
|
M.E.
Aged Yak Warrior
539 Posts |
 Posted - 2002-11-27 : 14:25:58
|
| I've been looking for a good topic to write my first article on... However I've hit a dead end pretty quickly. Any ideas for me? So far the only one that I've come up with that I have experience with is a script that compares data in 2 identical tables and updates the second table to look like the first. It has some uses, but it's very specialized (unfortunately) and only worth while running if you have large table (1 million rows) that join to larger tables (8 million rows). Not sure if it's worth writing though... Any suggestions?-----------------------SQL isn't just a hobby, It's an addiction |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-27 : 14:44:18
|
Identity and Primary Keys - Part IIMore Trees & Hierarchies - Part II Man, that would be a HUUUUUUUUUUUUUUUGE load off my back...j/kDunno if these are good TOPICS, but they make entertaining titles:Replication: How Microsoft Stole an Idea From Blade RunnerWhere the !%#*! Did That Table Go To Now???Cursors Are Da Bomb!Here's Why Third Normal Form SucksMulti-Valued Databases vs. Outdated Relational Theory: A StudyJoe Celko's SQL For People Who Ask The Same Question Over and Over AgainBacking Up Terabyte Databases To Floppies and PunchcardsWhen SQL Server Alerts Attack!SQL Server: The Next GenerationSQL Server: EnterpriseSQL Server: Deep Space NineFun Weekend Projects With Service Pack 3How Apollo 13 Is Very Similar To TRUNCATE TABLE master..sysdatabases |
 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-27 : 16:23:42
|
| Heh, now theres some humour that only a few people will laugh at.I should do one for the setup we have here... Tables with primary keys of varchar(40) and why not to use them :PI was just going with... now that I'm an aged yak I should probably write something useful -----------------------SQL isn't just a hobby, It's an addictionEdited by - M.E. on 11/27/2002 16:25:10 |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-11-27 : 16:46:36
|
quote:
How Apollo 13 Is Very Similar To TRUNCATE TABLE master..sysdatabases
That made my day. Justin |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-12-01 : 22:02:43
|
| seriously though (I know that's rare for me)how about a really good article on collation (I just emailed robvolk about this one) there's quite a few unanswered (or unsatisfactorily answered) posts out there....--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-12-01 : 22:35:02
|
quote:
a really good article on collation
Oooooh, an article on collation. Talk about a page turner. Crichton, King, and Koontz eat your hearts out.  just kidding, since I havent written any articles I shouldn't be teasing (but I can't help it).Justin |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-12-04 : 14:23:25
|
quote:
Multi-Valued Databases vs. Outdated Relational Theory: A Study
Rob, I warned you not to get me started on that topic... I became an expert in MV'd databases 12 years ago... And you couldn't pay me enough to go back to them!------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2002-12-04 : 18:24:04
|
| "MDX made easy" "Full-Text Indexing Support for dummies" "DTS - Beyond the import/export wizard""My first natural language query""The day the transaction log wouldn't shrink""File groups in real world applications""Techniques for minimising the amount of storage your hosted SQL server database uses"----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-05 : 06:45:16
|
| Backing Up Terabyte Databases To Floppies and PunchcardsFirst get yourself a ten thousand floppy jukebox.Need an interface to automatically swap to next floppyFloppies aren't very reliable so you will need a mirrored system to get two or more copies of each.Hmmm - numbering the floppies becaomes a problem.Needs some temps to swap floppies - or maybe they can come already stored in cartridges.Nah - think punchcards would be easier - writers already handle streaming. Just don't drop them (and think of the rain forest).Of course the database would need to be off-line for a few years while it's going on (maybe someone could estimate the time) or the backup will always be writing changed pages.This shouldn't be a problem as the restore will take a few years too so the company is obviously happy with this.Maybe I will write an article on it - know any places that want to be test sites?==========================================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. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-12-05 : 07:32:31
|
quote:
(and think of the rain forest).
Strange, I don't remember punchcards being made of exotic hardwood veneers. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-05 : 07:52:54
|
| You need to read the finished article.This is a critical backup so needs best quality punch cards.Why not just take the disc out and put it through the photocopier?==========================================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. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-12-05 : 08:33:05
|
quote:
Why not just take the disc out and put it through the photocopier?
One has to be careful to use a digital photocopier. Better yet, store a copy of the disk offsite by faxing it. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-05 : 08:39:54
|
| copy it, scan it, save it to disk, email it to your DR site and tell them to restore it.I believe you can get ClearData inc to come along and verify the procedures for a very reasonable price.==========================================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. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-12-08 : 19:37:45
|
quote:
Why not just take the disc out and put it through the photocopier?
Now you guys are just being really silly. You can't put the disc through the photocopier!!! It only feeds paper - you'll have to lift the lid and do the copy manually.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
Article Topics