happy to. Give me a day or 2 and it will be in your inbox ready for you to edit. 🙂

yeah... that was my first approach

It actually turns out that it was a memory issue. (it was quite a big database, so it took quite a while to go through...

just a normal backup database->restore database scenario

I'm going to try dropping the allocated memory on the target server and see if the issue is "not enough free memory to create...

  The theory of constraints says that there is ONE key constraint at any one time.  If your work addresses this constraint then another will emerge and it won't...

It worked out well because, when people ask me why their code had performance issues, I could tell them, "Well, if you had used the fn Tally function...

...

Lol

I work for a company that was founded in 1851.  our practices are built on fax machines. (seriously, at one point I dreamt that our DR scenario revolved around faxing...

while it's slightly off topic,

I worked with a  team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"

but I do agree with...

Herb (and anyone interested) - I highly recommend reading a book called "the phoenix project"

it details the story of and IT engineer in an engineering company, trying to get things...

• This reply was modified 6 years, 11 months ago by MVDBA (Mike Vessey).

without seeing the table structure or the data it is returning we will struggle to help

have you thought about using Row_number() over (partition by … order by …) as rn

add...

next you'll be telling us Santa Clause and unicorns don't exist

I hate "where 1=0" - I ..use  "where @debugmode=1" and pass that in as a parameter. the number of times one of my devs has hardcoded "where...

you could keep your existing clustered index on the publisher.

then set the article properties to not copy indexes. then create a post snapshot script that creates the clustered index to...

• This reply was modified 6 years, 12 months ago by MVDBA (Mike Vessey).

what type of maintenance plan?

are you just looking for backups ? RDS handles most of this in the background, as it does with patching

you can't really backup a database to...

Grant is 100% right

also front end developers in some cases build their child objects first, meaning they put "employee address" records into the database before they put the employee record...