Out of curiosity, is this your main post table or something else?

And which forum software do you use?

As Barry mentioned, the inserts/updates will affect performance. If the SELECTs are not being blocked by INSERT activity (which has to update each index) then you are probably OK.

First poster in 24 hours, I win!

Gail, any video?

Nice one, Phil.

Any support for transactions in the middle layer, should use the database. The issues of running it in the middle layer could potentially be communication issues in the...

Ten seems high, but it depends on usage, as mentioned. You would want to look at the stats, see if they are really used. Also check the missing indexes view...

You might look at SQL Sentry's scheduling solution for help with the jobs.

As far as making this faster, you would need to get execution plan for each insert/update and see...

That's interesting. I'd think that there would be no problem reading it offline. Maybe some JS we have. I'll give it a try and save some files.

Micheal, sounds like a good article idea (hint, hint)

Don't shut down the Windows host, shut down the SQL Server server instance. Use SSMS, right click, shut down SQL Server.

Or Control Panel/Services, turn the service off.

There is always a bottleneck. You just have to decide if it's an issue on your system. Once you fix that bottleneck, or mitigate it, there will be another one.

You...

Jeff,

I think there's a good call for a T-SQL book from you 🙂

The other thing is that most authors aren't thinking performance when they write. They might be when the...

Paul does a restart of SQL, and a restart of tempdb clear this up?

What is the problem you're having?

The generator has been in for a little over a year, works great, no issues. We still might lose connectivity if the upstream links die (it happens), but so far...

IBM can run their business however they want, but I don't want to support them, and neither should our government.