Viewing 15 posts - 41,491 through 41,505 (of 49,571 total)
madhu.arda (1/22/2009)
Is these dead locks are anyway related to having different collation settings.
Unlikely. Different collation would give you a collation mismatch error if there was a problem.
All I know about...
January 23, 2009 at 12:28 am
The_SQL_DBA (1/22/2009)
Paul, one question as a DBA what is the best way to avoid corruption in the first place..
I'm not Paul, but...
Ensure your IO subsystem is stable and performing...
January 22, 2009 at 2:26 pm
ashepard (1/22/2009)
Gail, do you have a good web rescource showing all the internal procecess that SQL 2005 or 2008 runs (log writer, dead lock detection, memory manager, etc)
I...
January 22, 2009 at 2:14 pm
Ummmm... forced parameterisation's not a band-aid. It can hurt more than help. It's used when you don't have access to the source code and hence can't change the queries in...
January 22, 2009 at 2:02 pm
PG (1/22/2009)
January 22, 2009 at 1:56 pm
DBADave (1/22/2009)
although who is to say the author is correct.
Connor's currently the program manager of the Query Optimisation team and, previously (iirc) was one of the lead developers...
January 22, 2009 at 1:35 pm
Network admins at my previous company didn't allow any of those to be used anywhere.
January 22, 2009 at 1:30 pm
You can always combine include columns without an effect
You can usually combine the inequalities without breaking anything, not always
You usually can't combine equality columns without causing a problem.
I blogged earlier...
January 22, 2009 at 1:29 pm
tgarland (1/22/2009)
I have thought about combining those into one index that looks like the following but I am not sure if that would make the index less valuable:
Looks fine.
This...
January 22, 2009 at 1:09 pm
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
Viewing 15 posts - 41,491 through 41,505 (of 49,571 total)