Jared, do me a favour please. Find sp_spaceused and modify it. What do you think? Good code laid out badly.

Eugene Elutin (3/19/2012)

---

Microsoft wants to show by example, that not using coding standards, ends up with great "dog's breakfast" :hehe:

I wonder what...

SELECT*

FROM#t

WHEREDateCreated >= ISNULL(@FromDate, DateCreated)

ANDDateCreated <= ISNULL(@ThroughDate, DateCreated)

You probably have a non-clustered index on the one partition. Each index is represented in sys.partitions.

SELECT o.name

,p.partition_number

,p.index_id

,p.rows

FROM sys.objects o

JOINsys.partitions p

ON o.object_id = p.object_id

WHEREo.type = 'U';

How to win friends and influence people :w00t:

Jack Corbett (1/26/2012)

---

Can you provide the DDL for the Foreign Key Constraints? I'm trying to figure out why there would need to be an Exclusive lock taken...

I can change indexes, partitioning and data types.

I tried changing the clustered index on TBL_PROPERTY but that resulted in TBL_REQUESTVALUES_OBJECT_PROPERTY dealocking with itself.

fahey.jonathan (1/25/2012)

---

For anyone else trying to read the SQL plan files, when I downloaded them, they showed up with an "xml" extension so I had to rename them with a...

I also get a blank screen when clicking the link, but I can save to disk and they open fine.

Here are the statements:

UPDATETBL_PROPERTY

SETKIND_ID = 1234

,FK_STRUCTURED_ACTUAL_ID = 5678

,SPECIFICATION_ID = 910

WHEREID...

Thanks for everyones input, I'm hapy to leave it as is then. My tests were conducted on a test server.

Before running each one I issued DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS.

I...

Totally makes sense. Do you have any thoughts as to...

This is the "normal" one using the CIX Scan

Table 'Products'. Scan count 1, logical reads 24452, physical reads 0, read-ahead reads 0

Table 'ObjectTypes'. Scan count 5, logical reads 134, physical...

Those are expected results when working with INT values. The /...

dbo.TBL_ACCOUNT

_WA_Sys_TYPE_ID_078C1F06

TYPE_ID, ID

CREATE NONCLUSTERED INDEX...