Viewing 15 posts - 286 through 300 (of 1,825 total)
Hmm , Why's are always tough questions to answer , you would have to go back to the very early sybase releases to find the answer. Though i doubt...
March 22, 2011 at 3:22 am
March 22, 2011 at 2:54 am
Why would you think that moving to express would make things run faster ?
It will be slower if anything due to express only using 1 cpu.
As for your report running...
March 22, 2011 at 2:51 am
This is expected behaviour..
Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate
http://msdn.microsoft.com/en-us/library/ms189794.aspx
You will have to account for the number of days through...
March 22, 2011 at 2:46 am
Try an outer apply rather than a join , judging by your use of top that is what you need.
March 21, 2011 at 7:22 am
I think Craig has got it , the amount of work the optimizer is doing to provide a 'good enough' plan is enormous.
Is the 'compile time' big in the execution...
March 21, 2011 at 6:46 am
Hmmm
There is a LOT going on in there, there seems to be a fundemental flaw.
The calling of any sql in a dynamic fashion , as you have done, would...
March 17, 2011 at 1:06 am
The two most obvious reason are
1) Failed inner join to tblPREE , there should be a foreign key relationship to prevent this.
2) The group by clause is doing...
March 17, 2011 at 12:46 am
sqldba20 (3/8/2011)
Dave, can you be more specific on which underlying design is wrong and which sort of problem I will be fighting?
Erm, this sort of problem you have posted about...
March 9, 2011 at 1:41 am
Hmm , you probably dont want to hear this , but your underlying design is wrong.
An EAV system will , pretty much, always cause this sort ofperformance issue.
Until that is...
March 8, 2011 at 9:08 am
@john-2 , it would work but its not SARGable. Or at least the date is not, which is what we are interested in here.
See the link i gave previously...
March 7, 2011 at 5:36 am
Try the AT Command Scheduler .
March 5, 2011 at 12:32 pm
Service broker is not a replacement for sql agent.
Do you have access to the "AT" scheduler command ?
March 5, 2011 at 9:28 am
Im a little confused as to your question,
Do you already know how to use service broker , and asking how to queue an event at a certain time ? ...
March 5, 2011 at 5:16 am
Please post the execution plans as per this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
It will take a lot of the guesswork out
March 4, 2011 at 11:26 am
Viewing 15 posts - 286 through 300 (of 1,825 total)