One way is to calculate the number of days that passed since your date, then divide it by seven and multiply it by seven. Since the function datediff returns...

Thank you for everyone that participated in this thread. I’ve learned a lot from it, (and also have more reading to do about the subject).

Adi

Did you check the event viewer for more details?

Adi

ChrisM@Work (11/4/2011)

---

GilaMonster (11/4/2011)

---

Lowell (11/4/2011)

---

well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did...

Lowell (11/4/2011)

---

well, the part i was trying to talk about was the screenshot below; see the difference for the "good enough plan found" vs the other that did not find...

You are correct that...

Those are the 2 queries:

--First query

declare @LastRunTime datetime

select @LastRunTime = '2011-01-16 00:00:52.870'

;WITH RankedRows AS (

SELECT ID,DataCLInd,SecField,Third,

RANK() OVER (Partition by SecField ORDER BY DataCLInd DESC) AS RowNum

FROM Inna

WHERE...

Lowell (11/4/2011)

---

A couple of Grant Fitychey's presentations he did on execution plans might be relevant;

as i remember it, the key to look for is the property "Reason For Early Termination...

Change the way that you export the data. Instead of exporting all the data export only the data that you want to show. Never count on an external...

One more way is to use the serverproperty functions with the input 'ProcessID'

Adi

I don’t think that those 2 things are related. I think that the TempDB’s growth had nothing to do with the increasing the memory of the server.

Adi

According to my memory, but more important this url:-) - http://msdn.microsoft.com/en-us/library/ms189315(v=SQL.100).aspx, you can run both types of backup at the same time.

Adi

I’m not a developer and not an export in connection string, but I think that you also need to add the driver that should be used (have to admit that...

When you work with XML variable, SQL Server only knows that it is going to work with an XML variable, but has no idea about the XML variable’s size or...

Take a look at http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx. If you don't find anything about the failed login in SQL Server's error log, then check if the server is configured to log failed...