Viewing 15 posts - 41,506 through 41,520 (of 49,571 total)
Grant Fritchey (1/22/2009)
I've been force-fed his chops before. The bruises heal.
Whatever did you do to deserve that?
January 22, 2009 at 11:40 am
DBADave (1/22/2009)
His answer was that they have witnessed the Optimizer picking incorrect query plans that have lead to performance problems.
Not uncommon, when one has out of date...
January 22, 2009 at 11:31 am
Bob Hovious (1/22/2009)
Never looked at the execution plan though.
Providing you haven't left a cross join in by accident, it'll be the same as for the one with JOIN.
January 22, 2009 at 11:21 am
Unfortunately, with sharepoint, there's not much you can do. You can't change the code and if you add any indexes, MS will no longer support you. From what I understand,...
January 22, 2009 at 10:29 am
JKSQL (1/22/2009)
January 22, 2009 at 10:24 am
ashepard (1/22/2009)
The "in-memory result set" - is that a table ?
Depends on your definition of table.
Do you refer to the output of a query as a table? If...
January 22, 2009 at 9:47 am
gyessql (1/22/2009)
select ...
from table t1
inner join t2
...
January 22, 2009 at 9:24 am
gyessql (1/22/2009)
Does this mean, instead of ON and AND, for readability ON and ON can be used?
No. They're not synonymous.
select ....
from ....
...
January 22, 2009 at 9:00 am
Bob Hovious (1/22/2009)
Grant, would you mind showing an example of how you would use joins in a where clause? I'm not sure what you mean.
Well, it's not the...
January 22, 2009 at 8:52 am
DBADave (1/22/2009)
Another statement they made in the doc is that we should identify the code causing the deadlocks and add indexes if necessary to resolve the problem.
Other problem...
January 22, 2009 at 7:59 am
Please post new questions in a new thread (in an appropriate forum) as people may miss it at the end of an existing thread, and SSIS people may well not...
January 22, 2009 at 7:58 am
So cast the uniqueidentifier to a varchar before concatenating.
Why do you have denormalised tables? What's the reason for putting lists into a single column instead of into a child table...
January 22, 2009 at 7:31 am
ashepard (1/22/2009)
Hi. Yes there is a temporary internal table for the resultant set rows that the cursor runs against I believe
That's cursors. Not general queries
For general queries,...
January 22, 2009 at 7:28 am
Nothing in the SQL error log at all?
January 22, 2009 at 7:12 am
Lowell (1/21/2009)
really, i think there are only like 6 questions that keep getting repeated over 90 percent of the posts, and the other 10% are the ones that we enjoy.
You...
January 22, 2009 at 7:00 am
Viewing 15 posts - 41,506 through 41,520 (of 49,571 total)