Make a calendar table. Here's mine : http://www.sqlservercentral.com/Forums/Attachment8839.aspx

Then SELECT * FROM dbo.Calendar WHERE Y = @Year

will give you all the dates for that year. You'll also notice...

And why do you truncate the table? That won't work multi-users!

lol, you know you have a big integration when you need to balance load the machine that balance loads all the requests to the other 100s of servers :w00t:.

Thanks for...

err. So how do you host the data??? The data should ONLY be on SQL server, nothing in access. That way it's always up to the second!

Forgot to add that I have a single xeon dual core with 4 GB ram 32 bit that handles a 25 Gb DB with 100 full times users + OLAP...

Maybe I misread but when do you do your index maintenance and stats update?

Feels like you could get a lot of usefull info by reading this (instinct).

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

I'm sure you've done...

Put a folder share on the backup folder.

Then restore with the path \\BACKUPMachinName\SharedFolder\prod-date.back

I usually give full control access to the machine rather than a specific user. You need to...

Guys that's why I said to run a trace with statement completed + statistics profile XML. That gives the actual execution plan for each step.

When you find...

You're welcomed, come back anytime!

Or losing / deleting the log backups on the drive. More rare but I've seen fat fingers before...

You're welcomed ;-).

Been bitten a few times by this one myself :hehe:.

Lavanyasri (8/2/2011)

---

Hi ,

Select * from sysproecessesm where blocked <>0 , you can find blocking SPID 's

Dbcc inputbuffer(spid) -- you can find the Current running Query .

First try to find...

Agreed, that's why I'm offering an overall solution which lets you did everywhere and that keeps log and query traces to pinpoint the problem rather than just guessing at it.

Eugene Elutin (8/2/2011)

---

"very slow query" from Lucky9?

Are you sure you have choosen the right nick? :hehe:

I would suspect that you do insert a lot into your table? Do you have...

Like I said, this was very down the list of possible suspect and now...