Sean Lange (2/7/2013)

---

Lynn Pettis (2/7/2013)

---

Everything looks orderd to me. I wouldn't use a while loop to populate the table dbo.Time2 and you really should not use Date as a...

Try this, it is an inline table valued function instead of a multi-statement table valued function:

IF EXISTS(SELECT 1 FROM sys.objects WHERE object_id = object_id('dbo.ufnCHFPatients'))

DROP FUNCTION dbo.ufnCHFPatients;

GO

CREATE...

Simple change, look at my code below:

CREATE TABLE dbo.Time2(

...

Everything looks orderd to me. I wouldn't use a while loop to populate the table dbo.Time2 and you really should not use Date as a name for a column.

See...

Heap tables don't reclaim space when records are deleted. To reclaim space you can add a clustered index to the table. Your table really should have one any...

ORDER BY MONTH(Dateadd(MONTH, -3,@StartDate))

Without your query really can't tell you much more than that.

Please do not cross post. This is basically asking the same thing as here: http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx#bm1416511.

Please post further replies at the above link.

k.srikalyan (2/6/2013)

---

Try to create a primary key/unique key on your table variable, and it is always better to go as a stored proc using temp tables and while loop...

Here is a good reference on how DATEDIFF works: http://www.sqlteam.com/article/datediff-function-demystified.

One, the ability to do point in time recovery of the database if it is needed. Having a mirror database is good for high availability but it doesn't replace...

No. Doing that will give them sysadmin rights to the entire SQL Server instance.

Mac1986 (2/5/2013)

---

Hi All,

I have a table in which one of the column is UniqueIdentifier. I have NULLS from records 1 through 91...

dwain.c (2/5/2013)

---

masoudk1990 (2/5/2013)

---

Im trying to...

One thing that your plan indicates is that there are no statistics on the the columns _col_1 or _col_2 on your indexed view. You might start there.

saxena200 (2/5/2013)

---

hahahaha.... at the end you have to trust DTA

well, inner query is not helping at all, Not getting any concrete solution for tuning this....

execution plan is not showing anything...