Sorry to say that my query and your query returns the same data with the design I provided.

It does not return 1. I am not sure how 1 is returning...

Select Stratogy_id,efct_end_dt From #T1

Where Stratogy_ID in

(

Select Stratogy_ID

From #T1

Where efct_end_dt is null

Group by Stratogy_ID having COUNT(Stratogy_ID)=1

)

Will the baove help you. (It looks like a home work!!!);-)

To help you better please provide you table structure....

I design what I got from your post. Let me know is this correct?

Create Table #T1 (Stratogy_ID int, efct_end_dt Date)

Insert into...

Has dim table with multiple entries with same stratogy id with date field as null?

Please provide the table structure and sample data to help you better.

I would recommand you to Comment the two function calls from the selecting resultset and see the result how much time ti takes to execute. Probabaly it might due to...

I do not know how far the below link would help,

However it would be a good starting point to further analyse your needs.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

Could you please go through the below sites for the instructions:

http://technet.microsoft.com/en-us/library/bb933995.aspx

I will come back to you with the sample script with my next working day.

First of all, plese try to void text,ntext and image datatype for new development work, this is going to be deprecated in future versions.

I would recommand you to look an...

Whats your current datatype of the column? Why do you look for to store the data in DB(any particular reason)?

sturner (8/29/2011)

---

I thought you were referring to the transaction log. You can compact the database file also if it is larger than you need to hold the data currently in...

I have never come across any issues so far.

--Identifying Top Objects Associated with Lock Contention

Use master

SELECT TOP 100

OBJECT_NAME(o.object_id, o.database_id) object_nm,

...

SELECT tl.resource_type ,

tl.resource_database_id ,

tl.resource_associated_entity_id ,

tl.request_mode...

"Use" should not be used just after the "UNION". Thats the issue here.

You have to provide 4 part table to access the same.

It might be good a look at it:

http://www.sqlskills.com/blogs/paul/post/inside-the-storage-engine-ghost-cleanup-in-depth.aspx