Beatrix Kiddo (1/3/2017)

---

I thought that too. I suspect some of those UK salaries are in £ not $. Well, I hope they are: http://www.sqlservercentral.com/Forums/Topic1847126-263-1.aspx%5B/quote%5D

I think some of the...

I never did, I'm afraid. If I recall, that piece of code was totally redeveloped into a stored procedure. In my honest opinion, I think it was something...

Thanks for the connect link; upvoted it, for whatever good that will do!

Fortunately in this case, I was only using the table in question as a demo for using the...

Jacob Wilkins (4/25/2016)

The implementation in this case is a bit disappointing, because from a high-level perspective it could pull just the top 10 rows by EventID from each partition, and...

Use an extended event session to monitor code that calls the TRUNCATE dbo.YourTable statement. Johnathan Kehayais has a great blog on Extended Events.

Yeah, looks like that might be the only solution. Seems a bit ugly; but hey ho.

Still waiting for the hot swapping functionality to be disabled, but in the meantime noticed that if you try and change the account in the SQL Server Configuration Manager to...

From further digging, it looks like it may actually be a VMWare issue. Currently testing the following, but have high hopes for this:-

https://support.microsoft.com/en-us/kb/2811670#/en-us/kb/2811670

There's a patch on there that I'm...

OK cheers. Will see if I can get that done (installs by another department) and see if it fixes it.

Hm, that's a bit weird. Wonder if it might be to do with some policy somewhere getting in the way? Was there literally no other changes other than...

Hmm, got this again on another server in a totally different environment and workplace.

Would be interested if anyone else has the same issue at all?

I can see after install that...

Good to know, glad you got to the bottom of it!

You need a model database there as the instance creates tempdb from that model, bit so long as you have the .MDF and .ldf for model in the location specified...

Do you really need to restore the model database? Does the instance start ok with the model db creating at install?

Yes, however, depending on how your table is configured then you may get into other issues in terms of performance if you're utilising the minimal logging advantages of the fsat...