I used to look at job requirements as rigid in that the company knew exactly what they wanted. Over time I saw it for being more of a ask/bid model....

"Enter the subscription, resource group, cluster and administrator account details."

---- these items are not predefined and just thrown into the context. This read assumes prior knowledge of cloud service architecture....

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