Ahoi,

the only way i know of to see the progress is in the "SQL Server Profiler".

• change the servertype to Analysis Service and chose the correct instance
• In there you...

• This reply was modified 4 years, 3 months ago by  ktflash.

Not actually sure what the goal is, so i am guessing a bit, both queries should produce the same result

1 Method is getting the Max  EEFDT values for CHAR_TYPE_CD in...

I a m developer (SSAS/SSIS) and familiar with the concepts of clusted and nonclustered indexes.

How much more about indexing/statistics/... should i have knowledge of?

What is "nice to have" and what...

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

This is a topic that is pretty close to my heart.

I finished studying march last year and started as new developer responsible for all SSIS and SSAS in a company...

Aggregations will help with performance and is definitely something worth looking at. You're right, proactive caching isn't really what you want to do here...you just want to warm the...

"Do not be afraid to ask questions"

I think this also applies to: Do not be afraid to post your anwers and solutions here on the forum.

Even if it is not...

FUCK MY LIFE

1. Reason it does not work is the following: This is by SQL (Server) design. NULL is not equal (or unequal) to anything. (good to know)
2. Business reason...

Since you are not using any anything from the the Locations table L in your select , what happens if you run this query with a distinct?

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

This post always appears on top of the "latest topic" section for me, is this for anyone else here aswell?

If not, has anyone an idea how to get it rid...

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

What John said is correct, it works perfectly the way he described it.

Depending on the real columns you use you also need to use the partition option

select...

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

" Learn about them, experiment, understand the impact they have on your audience, and choose the best tools for the job."

Any idea where to start with Data Mining?

• Is there...

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

Reading through this topic serveral thing i question myself came to my mind:

What is the best way to keep up with new sql server technologies and updates?

How often and how...

the query store is a useful tool, but as soon as your proc cache changes or you reboot your server then you start losing all of the valuable information...

The performance mainly depends on the indexes available for the table and how up to date statistics are.

If there is not an index that has person_id as the first...

Have you looked at the execution plan for this?   Depending...

• This reply was modified 4 years, 6 months ago by  ktflash.
• This reply was modified 4 years, 6 months ago by  ktflash.