| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-05-03 : 15:15:05
|
Slow day here ... needs some life. Anyone got something controversial to post?Where are the trolls? Anyone got something bad to say about SQL 2000?  |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-05-03 : 15:32:45
|
| <troll>If you havent got anything else on, perhaps you could help me improve the performance of my triple-nested cursorI have 1000 million rows and its running a bit slow, it takes 150 hours and it needs to be run everydaywould an index help ???</troll> |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-03 : 15:35:16
|
| Yeah, you should get rid of your current clustered index and create a covering clustered index that includes every row of the table. Can you let me know how that works out?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-05-03 : 15:52:08
|
| Nest the cursor even more, this way you break the processing up into smaller more manageable pieces - you probably won't even need indexing then.Another tip would be to use the substring function and loop through the length of each char column when comparing the data rather than comparing the column data as a whole.If this doesn't improve performance then you can rant and rave about how crap microsoft products are and what little use dba's are. You can post all of those comments here - The members love them.Happy Trolling!Duane. |
|
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-05-03 : 15:59:33
|
| if I used a pivot table, I would only have 10 rows to deal with, would that be quicker ? |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-05-03 : 16:00:28
|
quote:
Originally posted by gpl
<troll>If you havent got anything else on, perhaps you could help me improve the performance of my triple-nested cursorI have 1000 million rows and its running a bit slow, it takes 150 hours and it needs to be run everydaywould an index help ???</troll>
Here's one: I've got a query that doesn't return the values I need. What's wrong? |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-05-03 : 16:04:20
|
quote:
Originally posted by SamCHere's one: I've got a query that doesn't return the values I need. What's wrong?
Ah.....That would be the PEBKAC errorProblemExistsBetweenKeyboardAndChairDuane. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-03 : 16:15:16
|
| I need the middle 500 records....*And if you dba's are just too stupid to help me, I'll just go ask a developer....* (Note: Not rows...I don't want no stikin rows)Brett8-) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 22:44:46
|
| >> I need the middle 500 records....*Tell the users not to insert the one's you don't need.In the meantime delete them all - it will help to make the query more efficient and save space.==========================================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. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-03 : 22:51:57
|
| Then reorder the identity column so there are no gapsDamian |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-05-04 : 04:24:48
|
| Please help. I work for a major bank, and my database server just crashed. Some guy at the Microsoft forums said something about using the backups, but I dont know how to take a backup. Can I get one now?OS |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-05-04 : 09:00:08
|
(Sung to yesterday by the fab four)Yesterday, All those backups seemed a waste of pay. Now my database has gone away. Oh I believe in yesterday. Suddenly, There''s not half the files there used to be, And there''s a milestone hanging over me The system crashed so suddenly. I pushed something wrong What it was I could not say. Now all my data''s gone and I long for yesterday-ay-ay-ay Yesterday, The need for back-ups seemed so far away. I knew my data was all here to stay, Now I believe in yesterday. JimUsers <> Logic |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-04 : 10:49:14
|
| How to pick an SQL geek....when his apostrophes are already escaped Damian |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2004-05-04 : 17:51:55
|
| My problem is that my boss wants me to come up with database designs that incorporate lookup tables with foreign key constraints and such.I think it would be easier to put it into a flat table.I can't think of why Wal-Mart's inventory tracking and accounts payable/receiveable database should need any normalizing.Aj |
|
|
|
|
Slow day