I was looking at this just yesterday feeling somewhat unwell going away from looking at it during my lunchbreak knowing i did only understand some of it. This throughout and...

That is something that is really bothering me.

There seems so be so much useful metadata stored and available in SQL Server, but i dont even know where to start or...

Not a solution since am at work, but for the future, if you have TSQL Questions, rather than what u did, its much more helpful and easier for you and...

Maybe take a look into this:

https://www.brentozar.com/blitz/max-memory/

Maybe the environment variables in the job?

For those are too lazy to copy paste for testing, added 2nd Colum for True False:

create table #temp (
Date1 datetime2
   ,Wanted bit)


insert into #temp
values (cast('2020-08-26...

I never got into reading no-technical books.

I am now 27 and i havent read a single non-technical book outside of those i had to read for schools.

On the other hand...

• This reply was modified 5 years, 9 months ago by ktflash.

Most likely DMV (Dynamic Managent Views) is what you are looking for.

By creating a linked server to SSAS you can query SSAS Metadata via SQL

I might be wrong but is there a...

• This reply was modified 5 years, 9 months ago by ktflash.

I only recently started working with python in my freetime but as someone who only used SQL/TSQL i am struggling quiet a bit to get used to working with data...

Always feels weird to guess about stuff you never heard about, because to get the answer you have to submit one.

But something learned is something learned.

OK, are these date ranges included in your cube? If so, why are you doing that, rather than allowing the end user to perform the aggregation in a pivot...

• This reply was modified 5 years, 10 months ago by ktflash.

Its not calculated its just a number and the 2 date ranges (+ other dimension references)

Kinda offtopic, but since i am getting into python and therefore numpy,scipy and pandas.

It might be because i am just starting, but what are these basic features like pandas for...

Join the tables, group the result, pivot the result

create table #employee (
employeeNo nvarchar(20),
lastName nvarchar(20),
firstName nvarchar(20),
gender nvarchar(20),
departmentID nvarchar(20))

create table #department (
departmentID nvarchar(20),
"name" nvarchar(20))

insert into #employee(employeeNo,firstName,lastName,gender,departmentID) 
values('1','Tom','Smith','M','2')
  ...