PDA

View Full Version : Time to reboot or somethin?


ewallace
11-21-2002, 11:35 AM
I noticed that the main page of the forum, and any of the thread list pages of the forums are pulling very, very slow. Sometimes posting replies is very slow too. It's been going on for about 2 days now. Is it just me?
Stranger
11-21-2002, 11:47 AM
same here
norther practitioner
11-21-2002, 12:23 PM
ditto
txwingchun
11-21-2002, 12:41 PM
Nope it's slow

ewallace to answer your question of course Royce could choke out Rerun there's no one he couldn't choke out he's invincible.:rolleyes:
But the real question is could Royce choke himself out?
IronFist
11-21-2002, 05:55 PM
Beer.

IronFist
GGL
11-21-2002, 07:28 PM
They need to reboot and rebuild their indexes.. i mean really man.. that should be obvious.. right???


oh yeah... I LIKE CHEESE!!!
ewallace
11-22-2002, 12:05 PM
Actually GGL, I was thinking a simple order by would be in order. By. ;)
GGL
11-22-2002, 01:38 PM
obviously your aggregate function of your order by statement would inhibit the primary key constraint in which the null statement would be chosen.. and we all know that nulls and constraints don't mix.. obviously you would utilize the having statement with a inner join and a nested select *:D :D

God imagine how far buzz words can take you;)
rubthebuddha
11-22-2002, 02:47 PM
Originally posted by GGL
obviously your aggregate function of your order by statement would inhibit the primary key constraint in which the null statement would be chosen.. and we all know that nulls and constraints don't mix.. obviously you would utilize the having statement with a inner join and a nested select *:D :D

is it just me, or is GGL flirting with ewallace? :confused:
GGL
11-22-2002, 03:21 PM
Dude I'm mean dude, really dude.... I see you are not verse in the words of geekdom:D
GGL
11-22-2002, 03:22 PM
kool avatar!
ewallace
11-22-2002, 03:24 PM
Question for you GGL, since you seem to speak my language. Say you have a stored procedure. That procedure fires off 8 more stored procedures. On my system it works fine. On the system they are supposed to function on, the data produced is not the same. Now, both are on SQL 7. Both are using the EXACT same data from the exact same tables (I know, because I cleared 33 tables and imported the data from the other system). The permissions on both are the same.

WTF?
GGL
11-22-2002, 10:08 PM
hmm upgrade to sql 2000 :D :D

no really.. it sounds like you have produced a local sp that acts like a trigger to fire off 8 others.. I may be wrong on this but what is the orginal call.. calling for.. a select, update or delete, and is it fired off after the orginal call or as a alternate... can you give me some code.. if not no sweat..

G