Viewing 15 posts - 41,491 through 41,505 (of 49,562 total)
K. Brian Kelley (1/22/2009)
Sorry, folks, but we have had solutions to prevent unencrypted data flowing across the data into SQL Server. 🙂
We have em. The question of who uses them...
January 22, 2009 at 12:55 pm
DBADave (1/22/2009)
32GB of memory.
From those stats, SQL's using maybe 200MB of that for proc cache. Not much
They have a lot of dynamic code executed from their application servers. If...
January 22, 2009 at 12:53 pm
Hollyz (1/22/2009)
January 22, 2009 at 12:51 pm
DBADave (1/22/2009)
He said re-use(%) is low and asked to see our L2 cache. How does this pertain to L2 cache?
It doesn't. That's looking at details of the procedure cache,...
January 22, 2009 at 12:42 pm
Won't that only happen if multiple CPUs (multiple running worker threads) are after the exact same data at the exact same time?
Dave: Talking about the processor cache impact on performance...
January 22, 2009 at 12:05 pm
Roy Ernest (1/22/2009)
January 22, 2009 at 11:49 am
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
Viewing 15 posts - 41,491 through 41,505 (of 49,562 total)