Hmm. I am not so sure. I had an issue where the query plan kept regressing due to an issue with memory grant on a table with a large varchar...

And, just to assure you this type of thing does work exactly as I've stated (and I'm sure that Eric would agree), I have a 2005 database that just...

Shurgenz (8/4/2014)

---

when creating the new index on a large table that already has some indexes, the new index could take a long time when tehre is alredy index with...

Shurgenz (8/4/2014)

---

when creating the new index on a large table that already has some indexes, the new index could take a long time when tehre is alredy index with...

Thank you Grant for bringing up the important subject of self care. There are numerous youtube videos that you can find on the subject. But they all seem to converge...

Yes , well stated.

PHXHoward: Do you happen to have an...

Hi All,

I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.

1. In which order the rebuild and update stats run....

Thank you for that good information. I will start to look into this direction.

Hi Steve: I am facing a similar issue on one of our databases. 100 % new plans in the last hour. I was wondering if you ever found the cause...

I am not sure you would want to automatically commit open explicit transactions. If you lose a connection on update 2 of 3 and you commit then you are left...

Perhaps I am not understanding your need. What I am reading is that you make changes to your client records (without naming the table that contains the clients)  and...

Perhaps I am not understanding your need. What I am reading is that you make changes to your client records (without naming the table that contains the clients)  and...

You would want an Explicit transaction if you were doing an operation , for example, on two tables in a way that they both need to maintain integrity. For example...

To add to the question on losing a connection that may be in a transaction,

We have had site down maintenance and to where the network is just brought down. The...

It sounds like there is a particular index that may be taking a lot longer and blocking the processing of others , especially if you set a time limit on...