DBCC SHRINKFILE ?

You want to do this on the primary. I know growing them will propagate the same to the secondary nodes, but have not done a shrink before. You...

For readability I suggest indents , but more importantly this looks like it could use EXISTS clauses and not sure why the same values criteria appear more than once.

This is a very relevant article and far too often code is written in such a way that Log space is consumed as a result of attempting to delete...

We had the same  problem today.

I wrote a script that does the following:

• Starts a transaction
• retrieves the last id number of the table
• uses sp_rename to rename the...

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