This seems like one of the times where triggers are the right mechanism.  There's no complex logic in the trigger, there's nothing complicated happening to the table, updates/delete etc.......

Take a look at the Azure measurement DTU. This is how Microsoft was primarily charging, per database, for Azure. Now, the DTU is largely a secondary measure and they're primarily...

I haven't set up something like this, so let's get that out of the way up front.

First thing that comes to mind is simple INSERT triggers. However, generally, I don't...

That one is simple. Not enough memory in the system for the query in question. That means also, not enough disk space to swap stuff out. Sounds like the data...

Resource Pool Statistics are specific to Resource Pools which are how the Resource Governor works. You don't have a Resource Governor in Express Edition. Therefore, no need to look at...

I'd suggest removing the job entirely. However, probably, what you're seeing isn't the job restarting. It's probably rolling back since you killed it. You'll need to just let that finish....

No, we didn't make enough. Other stuff is being worked on. There are plans and plans with plans. All the details will be released soon.

• This reply was modified 5 years, 5 months ago by Grant Fritchey.

Nope.

Nope. Not without tons more information. What do the wait statistics look like? What's causing it to slow down?

It's also just possible that you're not CPU bound. In fact, it's pretty common to run out of other resources first. Disk I/O and Memory are much more frequently the...

@Grant ,

Yes, that was my intention take a chunk of everyday data rows and execute some sql code/agaent job against the table.I am sure the datatable per day will...

There isn't a way within the database alone to do this. You're going to have to go external to the database and set up something that polls the data. Now,...

You got it. sp_updatestats uses a sample method instead of full scan. It means it's faster, but it's less accurate. There's always a tradeoff deciding which to use, so you'll...

Fragmentation and statistics are two completely different, though somewhat related, things.

Fragmentation is simply about storage on the system. A page gets allocated to an index. Data gets put into it....

This year was my first PASS Summit. I've wanted to go for quite a while but there was no way my employer would spend the money needed to attend...