Have you tried combining the queries into 1 query?  You could use a CTE to produce the aggregates and then join those to the details.  Your query would then fit...

I personally dislike sub-reports because I have seen too many performance issues.

Have you tried combining the 2 tables into 1 table?  That should work and make page breaks easy to...

Thanks for posting this.  I monitor the SQL Server error log and I get alerted to SSRS report execution failures.  However, I don't proactively monitor the event viewer logs.  I...

Thanks for sharing!  A successful developer is one who is skilled in the requisite tools AND is confident is his/her creative ability.  A developer is a creator.

Thanks Grant!  I created a reminder to read through your book!

Hi Dmitriy.  I worked with your example a little today, but I'm short on time.  The problem may be that bcp is not handling the NULL properly based on your...

Hello.  Did you resolve this?  If not, you may want to consider putting pictures and code into your post without using a zip file.  I wouldn't download and open files...

Hello.  I'm not sure if you are still looking for feedback on this, but I have a thought.  First, whenever possible, I think it's good to step back and look...

Did you notice that you would get a seek and nested loop join if you turn the Legacy Cardinality Estimation option on?

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

Thanks Ben.  I'm looking at this now.  For sure I can say you have put together one of the most detailed and cohesive forum posts I have seen here on...

I'm not sure that frequent updates are a reason to rule out columnstore indexes.  I'll have to check that out.

Are you able to share your table DDL and query?

Hello.  Consider some research into SSAS Tabular.  One big feature of Tabular is that the model does not need to be star or even snowflake.  Tabular is all in-memory and...

Hey Ben.  This isn't a direct answer to your question, but I think it's best to respond after understanding the context of a problem.  Can you not get adequate performance...

Reports and dashboards are great.  I use them regularly for monitoring.  The downsides for me have been time delay and oversights.  An alert could be set to near real-time.  Also,...

Try something like this:

delete from dbo.test2 
where KeyColumn in (
select t.KeyColumn 
from dbo.test2 t 
where t.ErrorDate <= DATEADD(month,-6,getdate())
)