d'oh sorry I forgot the square brackets!

So is it just me, or does that white sheep in the SQL Clone banner adds remind anyone else of Shaun the sheep?
http://www.shaunthesheep.com/

easiest way is to use the SP_MSFOREACHDB extended stored proc:

CREATE TABLE #SchemaList (db_id int, db_name sysname, schema_name sysname);
EXECUTE sp_msforeachdb 'USE ? INSERT INTO #SchemaList SELECT...

If you were to make 2 indexes for the columns, what would the other one be?  Creating a unique constraint does create an index so that isn't any different.  One...

After restoring the SSAS database, just make sure you repoint your Data Sources, so that the cube will use your testing SQL Server database not your production SQL Server databases.

The schema permission issue you describe in SQL Server may be related to what's called ownership chaining:
https://www.mssqltips.com/sqlservertip/1778/ownership-chaining-in-sql-server-security-feature-or-security-risk/
If the schemas have the same owner (many times DBO) then it's...

You can get a more detailed peek at CPU usage by looking at Performance Monitor in Windows, or even some recent history using the Ring Buffer in SQL Server:

actually SQL Server does let you add a foreign key to a unique constraint such as this, you just have to reference all the columns in both sides of the...

The thing that I find best helps me is hiking.  I'm fortunate to live in an area that has a 33,000 acre national park just 5 miles from where I live with...

to fix Steve's, the CTE query needs a DISTINCT in it otherwise it returns 2017-03-28 3 times:

with top_dates as (
    select DISTINCT top 3 with...

you may be able to use the application name property of the connection:
https://docs.microsoft.com/en-us/sql/t-sql/functions/app-name-transact-sql

Even if your application doesn't set it, you can still tell SSMS.  I've used code...