You should be working on finding out where the extra load is coming from. SQL Profiler is probably going to be the best bet but looking at sp_who2 may...

Jeff Moden (4/5/2010)

---

Yes... it seems that everyone approaches the problem of 3rd party code incorrectly... they try to fix it themselves. Get that bloody vendor off his haunches and...

Jeff, thanks for catching that. Any particular reason that you switched from charindex to patindex? Charindex can handle multiple characters and I'm assuming there's a reason you decided...

Personally, if possible, I like the idea of storing the list of values in a table better because it ends up being more flexible. But if that doesn't work...

Are there any CLR procedures on the server? If so it's possible that one of those has a memory leak. Have you tried monitoring the available RAM over...

When you shrink your log file you will break the transaction log chain and cannot use your previous logs to restore to a point in time, so it would be...

Which isn't to say this is a bad place to come once you figure out what needs to be done. I wish I could answer your question about encryption...

It sounds to me like you need to find a lawyer or consultant that specializes in healthcare security. I work in the healthcare field and we even get misinformation...

There are a few ways to do this. You can create a table that has a list of indexes used each day (remove the check for null stats change...

I think that will depend largely on how closely the order of the inserted data matches the order of the clustered index. If it matches then SQL will be...

It's frequently quicker to create a non-clustered index with the data already in the table than to do a bulk insert and reindex.

Just like indexes any additional statistics create maintenance overhead in both space used (it has to store it someplace) and the duration of maintenance (it does take time to update...

We've implemented a custom reindex job for our clients and had issues where, if the indexes were really, really bad, it would run into production hours. Here's a snippet...

We do the same thing with the application I support. We use the dynamic SQL method that Michael posted to do this in most of our scripts. One...

Cursors tend to be a very slow way of updating or deleting multiple rows. Sometimes there isn't any other way but if there is then not using a cursor...