The reason people setup jobs such as Ola Hallengren's scripts or to maintain statistics is that the Auto Update Statistics setting is often not enough to keep statistics up to...

Does your database have some way to identify the hierarchy of accounts?  This feels like something that would be better represented by data than code.  Then you could group by...

Jeff,

That is true, but since the OP explicitly asked about bridge tables in data warehouses, I figured I'd give them the best resources I know of instead of telling them...

A great reference to data warehouse design is the Kimball Group.  They have an article on bridge tables and an example here:

https://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/

They wrote the book on data warehousing and...

At home I tend to rebuild my main PC every 18 to 24 months, and then re-purpose my former desktop into a server.  Not necessarily elegant but gets the job...

The results with the UnitID and ProductID of NULL are the ROLLUP records, and represent the total count of records in the table, not a skew in the data.

I also think the DENY CONNECT and later GRANT CONNECT is an odd way to do this.  What I've typically done is instead of

ALTER DATABASE [DBname] SET SINGLE_USER WITH ROLLBACK...

A good way to evaluate an environment you are new to is to use the Blitz scripts from Brent Ozar:

https://www.brentozar.com/blitz/

Those scripts will help you find the problem spots in...

Yes, you are correct that the Application Role always uses a separate password, even if the user is logged into the database via Windows authentication.  The Windows authentication allows user...

I agree with Phil and pietlinden, the only way those criteria make sense is if you evaluate these separately with an OR between them.

In the documentation, you see that the Application Role is something completely separate from the authentication of the login.  If user Joe Smith logs into an instance as either Windows...

I think you're only getting a partial picture based on your queries you posted.  I do something similar for disk space, but to get each database's file usage I query...

Since we don't know what the 2 datasets look like it would be difficult for us to tell you where to start other than high level generic answers.  I'd start...

I'd suggest doing the set based work in your query rather than through expressions in the report.  I can think of 3 ways to do it offhand, though I'd like...

Do you know what is running at the times that the sudden drops in PLE occur?  PLE doesn't really have a maximum, and doesn't drop unexpectedly unless there are queries...