because temp tables are transient you will really have to catch this exactly as it creates the problem.

I might think about monitoring tempdb for any table over 5GB (a guess)...

trust me , i'm already shuddering - i'm asking because I want to get it right 🙂

so this is really cool info and so much better explained that msdn. I can't go up to 4 nodes, so would you recommend I drop down 2  rather than...

I'm being thick here  - (that happens a lot), but why does an odd number of nodes not help? I'm more of a query plan guy and I've been dumped...

by the way - all of it is on site. no data centre, we have our own greenlake/nimble san and a new beefy server for consolidating licences and removing linked...

the sync pair are within 2 meters of each other, the asycn is 400 meters away

(we have plenty of other DR policies in place - don't worry) - but the...

One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back...

Even better... does anyone know a company that coaches in HA technology (UK based) ?

One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back because they...

welcome to Nottinghamshire, linney are 16 miles north of the city centre

there is a great SQL meetup event (a few lectures and pizza)  soon near the train station

and SQL Data...

you'll love it there, Redgate has been listed as one of the top 100 employers in IT (as far as news articles go), but I think Linney's offices are nicer...

I'm on the same journey - we (meaning me) do restores from the latest backup once per month, split up throughout the month

we don't do DBCC checkdb on...

get rid of the sql agent jobs

they don't always disappear as you might expect

also - when you recreate everything your distributor is going to need passwords, get these in a...

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

I'm looking for some feedback from the community. I finally got permission to setup a server to do test restores. Yes, I know, you don't have backups until you...

I've just done a quick scout on the issue (I never use update in join, so it's a nice refresher)

Microsoft SQL Server does not permit updating fields in multiple database...