Any indexes or keys? Can you post the .SQLPLAN file?

This query:

Select * from sys.tables

will give you both create and modify dates. I do not believe that create and modify dates are maintained for columns.

Note that this works also and requires only one SELECT:

SELECT account

, COUNT(*) AS [count]

, Count(*) Over(Partition By 1) as [Total_Groups]

FROM #dxhistory

WHERE rank = 1

GROUP BY account

HAVING COUNT(*)...

Note that this is different on SQL Server 2005 than it is on SQL Server 2000. You would probably not have the same problem on a remote linked 2005...

"Near Miss"

This will also work with you current formula, just by adjusting it by 2 days:

Select cast(25567 + 1205894254/86400 as datetime)

union all Select cast(25567 + 1205895171/86400 as datetime)

union all...

We cannot really tell you much in this case, without more information. Please see this article on how to provide this info: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hmm, I thought the Crypto functions were off the table?

Can you just give us the before and after *.SQLPlan files?

Lowell (8/15/2008)

---

rbarryyoung (8/15/2008)

---

This raises an interesting question: how quickly can we generate an acceptably random pseudo-random sequence in SQL Server, without resorting the obvious built-in functions (rand, NewID, Checksum,...

andrew gothard (8/15/2008)

---

Sorry - totally disagree. Give me...

This raises an interesting question: how quickly can we generate an acceptably random pseudo-random sequence in SQL Server, without resorting the obvious built-in functions (rand, NewID, Checksum, the crypto...

Fair enough. My...

Ah. Well then, carry on. 🙂

Well, I think that you would need to detach the database before you removed the drive.