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...

It is better to not just designate an arbitrary integer as your clustering index. But instead consider how the table will join to other tables and be filtered.

If you are...

Aside from what been said, If your data has changed then see if you need to update index stats especially on your heavily used tables.

What ever your rules for matching are , For example address matching, you will need to join the table with itself. Something like  ? >

Select t1.custNo, t2.*,...