Viewing 15 posts - 1 through 15 (of 165 total)
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...
February 25, 2020 at 2:10 pm
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...
February 24, 2020 at 3:17 pm
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...
February 24, 2020 at 1:48 pm
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.
February 14, 2020 at 1:36 pm
Thanks Grant! I created a reminder to read through your book!
February 13, 2020 at 1:59 pm
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...
February 5, 2020 at 8:16 pm
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...
December 16, 2019 at 4:18 pm
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...
December 16, 2019 at 4:14 pm
Did you notice that you would get a seek and nested loop join if you turn the Legacy Cardinality Estimation option on?
December 13, 2019 at 1:15 pm
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...
December 13, 2019 at 1:10 pm
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?
December 12, 2019 at 4:11 pm
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...
December 12, 2019 at 2:13 pm
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...
December 12, 2019 at 2:05 pm
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,...
December 2, 2019 at 3:26 pm
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())
)
December 2, 2019 at 2:12 pm
Viewing 15 posts - 1 through 15 (of 165 total)