I have found my self doing this a few times. I have had a number of
circumstances where it has been required.
> -Original Message-
> From: jon hall [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 12:45 PM
> To: CF-Community
> Subject: Re: SQL Wackiness
>
holy cow! I feel your pain man...I think these dba's do this
kind of stuff on purpose, simply for job security.
Once things get that layered, I know I would have difficulty holding
all the pieces in my head at once. I hope you have a big monitor ;)
--
jon
mailto:[EMAIL PROTECTED]
Tuesday, Dece
You don't know how many times I've tried to tell our so called 'dba'
that. At this location, we're joining views upon view upon views. I
was trying to debug one view that was #8 in a succession of views, and
each one of those was made up of at least 3 joins inside.
Marlon
jon hall wrote:
>W
kins,Patrick wrote:
>>Maybe it doesn't like being called a dummy? :-) Seriously tho, did you get
>>it figured out?
>>-Patrick
>>
>>
>>
>>>-Original Message-
>>>From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
>>>Sent: Monday,
;it figured out?
>-Patrick
>
>
>
>>-Original Message-
>>From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, December 02, 2002 6:02 PM
>>To: CF-Community
>>Subject: SQL Wackiness
>>
>>
>>This is really, really weird MS
Maybe it doesn't like being called a dummy? :-) Seriously tho, did you get
it figured out?
-Patrick
> -Original Message-
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 6:02 PM
> To: CF-Community
> Subject: SQL Wackiness
>
>
This is really, really weird MS SQL Server 2000 behavior.
I have a view on the server that when I run this query:
SELECT * FROM myView
It takes about 18 seconds
When I run this query:
SELECT Dummycol, DummyCol2, DummyCol3 FROM myView
It takes 20 minutes
Has anyone else seen this behavior