Shameless plug: Something more comprehensive is in the works, but not in the immediate future. 😀

To do that, the user running that code requires impersonate permissions on User2. That's a fairly high-level...

For anyone reading this, dumps are...

If you remove the database users, the person can still log in and access the server. Depending on their server-level permissions, they may still be able to access the databases.

If...

Specialist, in something you enjoy, not the latest thing that pays well. But keep in mind that specialise doesn't mean you know nothing about anything outside of that speciality. You...

And the backup before that? Or older ones? What's the newest...

info.sqldbamail (4/26/2016)

---

We have production SQL Server 2012, where we had allocated Max memory of ~60 GB and Min Memory of 4 GB, We have the following situations and if it...

No, but other than the time that the manual stats updates take, not too much downside either. They're not large, and those that aren't useful won't get autoupdates triggered.

You can...

Wow, that's a new one

Anything interesting in the error log?

In short, yes, maybe and yes.

Dev and Prod absolutely have to be separate. Permissions is one reason, people who have high privileges on dev often shouldn't have elevated rights on...

Just one point. CTEs don't start with a ;.

The semicolon is a row terminator. Your code should be

declare @Parameter nvarchar(4000);

set @Parameter = 'Urbanisation';

With tmp as (

Select Count(*) as Base, DayOfInterview,...

Jeff Moden (4/22/2016)

---

It works but...

vivekshekhar-743222 (4/25/2016)

---

I guess you need to refer DEPTCode without prefixing it with P. as Deptcode is not present in the stage_chris21.PSDET table. Try the below code and see if...

Could you be more specific about the exact message you're seeing?

Ah, yes. Forgot about that. You have to patch and enable the traceflag for the incorrect allocation page problem to go away.

As for the XML, no idea. Have you checked...