Hello

I know this issue is quite old however I will add my comments for anyone invesigating this issue. We had a similar problem in my workplace with performance degradation as...

Hey

I've run

SET STATISTICS PROFILE ON

go

Before my query but the extra grid with the execution plan was not displayed. I have attached a screen dump of the execution plan, I...

I used the following method to remove any obsolete procedures

I ran a trace to pick up all stored procedures that were being referenced over 3 months. I then put the...

Hey

I've attached a script that may help you. It shows all the indexes in the selected database and orders them by the user_seeks which is basically how many times...

While you guys are on the topic of copying a 2008 database to an older version, I am currently putting together a failover plan after upgrading from 2000 to 2008....

This query is used in a report which is run maybe twice a week. The application uses this table a lot more and there are a lot of lookups on...

This query is used in a report which is run maybe twice a week. The application uses this table a lot more and there are a lot of lookups on...

Hey Lynn

Thanks for the quick reply. After having a detailed look at the execution plans i managed to hit the nail on the head

I compared the 2 execution plans and...

I had a similar problem with one of my queries, what i did is hard coded the date time values into the where clause and ran the query, then used...

Awesome, thank for all the help guys, thought there might have been a function that made it a bit easier

Hows this

select ALLocID,count(*)as 'No Of times visited' from dbo.allocationvisit

--where visittime = 'Enter date here'

group by AlLocID