if it is it's very well hidden - although I'll admit searching 2008 R2 BOL is "difficult" it's usually easier to use Google to find entries in BOL I find...

A client has bought a phone dialling system which uses sql server - this is a system which works through phone lists calling people up and as the calls connect...

you usually find more than one instance when locks are a problem - you should be able to find the object/key/page involved and drill in for more detail.

If it's multiple...

so is your storage san, das or internal?

I can't think of anything offhand which might cause this from a SQL service pack, other than there may ( probably...

so how many posters here are using SSDs or have tested sql server with SSDs or solid state memory cards ? Just interested - not having a go...

I think it's all down to what performance you need. In extreme tests I was able to show that for inserts adding secondary indexes to a table could degrade...

the generic way to deal with nulls is usually to use an isnull command, or if this doesn't exist in the language you can achieve the same thing with coalesce....

the indexes must be made upon the partition schema too - here's an a code snippet from one of my tables to illustrate table and secondary index - if you...

you're not thinking of physical and logic data models are you?

ok so it's a poor way I described it: However it's still possible to get better performance on a database by using multiple files and you're more likely to...

if you're trying to use the passive node then that's what I'd expect.

However I just checked on a w2k8 cluster and I can happily run perfmon from the passive node...

It's really one for "It just depends" , the theory behind the multiple files is that each cpu core can support a read/write thread so in theory you can...

I assume the cluster is failover with a passive node?

In which case I'd probably expect that to happen as the other node is not intended to be used - think...

I've not tried to write a generic query to show how the data is distributed in a partitioned table - here's a query I use - you'll need to add...

so many non answers! Yes Greg you can do exactly what you want like this:

--

-- get proc handle

--

SELECT plan_handle, st.text

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

WHERE text LIKE N'%dbo.name_of_the_proc_here';

GO

--

--...