You could track the times in sys.jobactivity. You would need to create an average, or max, or whatever statistical calculation you want. Then you'd need to track the current execution...

The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't a user clicking and posting like you....

I know this is old, but did you recover things?

Also, please don't set emergency or use repair allow data loss. You have errors in low numbered system objects, which are...

Thanks for noting that I mirror Keith poorly. :hehe:

DonlSimpson (11/24/2015)

---

Yeah but isn't that using a butter knife as a screwdriver? Certainly you can, and many people and organizations do, use the database server as the staging area...

I was using window functions, and this appeared to work, but it's a small sample size, so perhaps there's a flaw here:

SELECT t.*

FROM ( SELECT top 10

...

IMHO (11/24/2015)

---

I think they call...

swwg69 (11/24/2015)

---

Corporations allow the owners to have limited liability. That also makes the guys making the BIG money more casual about these problems. If someone took 100 million...

don't drop your framework or view on table design.

If I'm staging data here, pulling from unclean sources, do I need a PK or non-nullable columns? It's a perfectly valid design,...

What's previous?

The order of rows has no meaning in SQL Server. The way you insert them doesn't matter.

Right now your second row has a larger id and a later last...

I'm not sure it's that hard to go from 2005 sp4+ to 2016. The core features are there and not much has been removed, though lots deprecated. I suppose if...

Ed Wagner (11/23/2015)

---

Steve Jones - SSC Editor (11/23/2015)

---

So, the filter is learning, though it misses some I...

Andy Warren (11/23/2015)

---

Spelled subscription wrong:-)

Its interesting to see MS moving to the subscription model and doing so at reasonable prices. For most employees Im not sure it matters - they...

I'm not sure that's true. The cost of the licensing might go up, or might not. MS has maintained prices for two versions at times. In that case, maybe it's...

So, the filter is learning, though it misses some I don't understand.

However the filter scans post-post. This...