SQLRNNR (1/7/2013)

---

Looking at this query, I wouldn't look at indexes with an improvement_measure of less than 1000. But that is nothing set in stone. It is a starting...

Some years back I was at a company, and we had one employee who would not lock his workstation.. 70%+ of the time. Also thanks to his personal connections, he...

Thanks for the help, Lowell and Jeff, I will do that... it was pain the other way. Thanks for helping folks like me... and Merry Christmas! 😛

The remote is set to 600 seconds. So this looks like the problem. Thanks.

Ok, thanks for the help 😀

Ok.. but how do you put that select logic into a delete statement?

True, just a personal quirk. I find that when I am trying to think through something... I tend to code the thought process. Thus the outer join filtering where not...

Hmm thought it would do a line by line check.. turns out that my thought process was off anyway. Given that we have data here that is not in SAP,...

Thanks Sean, I use the numeric data type so seldom I often forget about it. (I tend to use float or one of the int)

Oh, and I am also using @@rowcount to show the number of records. After this things will get a bit interesting.. since I will have to capture things that would...

It is datetime..

declare @startdate datetime

and I am using getdate() to load into @startdate,...

There is a third party that handles these databases.. my history with cubes is in PICK, not SQL Server. Can you tell from the create statement if it realy is...

Thanks... being a counter since reboot.. the term /sec is worthless then. Thanks for the help and the work around!

Ok, thanks... will do.

ThomasRushton (9/19/2012)

---

Ah, the joys of using undocumented stored procedures...

Note that there's a "feature" in the SQL2005 RTM version of that xp too - it won't traverse subdirectories, as...