Jeffrey,

Yes, it works great. I'm just interested in the question of how you can not group for each user a specific amount, but simply display the total number?

Sorry to confuse...

Jeffrey,

sorry I confused you.

it's just a fake value that needs to be written on the side (as select 'user').

That is the look should be:

Hi all,

yes, I got it. Thanks.

I only try to remove users and group only by date

Hi Jeffrey,

thanks a lot.

But the problem is that the data for the previous months exists. But I don't need them. I need data from the beginning of the year until...

This should be the total number of minutes for each previous month separately and their total number. We do not return to the previous year, but start from the current...

Brain,

my SSRS Report Version is © 2016 Microsoft, Version 13.0.5026.0

and the last version of the Chrome.

But I'm working on RDC - Windows Server 2012 R2

Hi Brian,

Did you test this option (on the screen)?

Because I have just updated all my browsers (Edge, Chrome) and nothing changed..

Scott, but why do you put the clustered index in the non-clustered? It is important?

Because when the first column in the select statement will be the clustered index and I...

Thanks, I got it.

The whole table contains 29 million and when I use DateDeleted is NULL I have 12 million of records.

Thanks. But where will be better to include DateDeleted in the main part or in the INCLUDE condition?

1. LastName, DateDeleted INCLUDE(FirstName)WHERE (DateDeleted IS NULL)

2. LastName INCLUDE(FirstName, DateDeleted )WHERE (DateDeleted IS...

Thanks, Grant.

I would like to ask also when I have only one index (a clustered index ) on the table and this index has a lot of seeks and scans,...

I focused on the statistics of the indexes using. For example,

LastName (NC index) has more than 8 million seeks, any scan, and a few updates.

FirstName (NC index) has only 7...

The biggest problem is that I have no specific query. I have several applications that use a database. When I try to find queries using a profiler, I get hundreds...

I have already seen that this query was blocked by the same query.

I have an API using which users receive responses.

At the same time, different users want to receive the...

Does "index disabling" blocks a table?

Do we have any constraints regarding it?