Viewing 15 posts - 61 through 75 (of 611 total)
September 29, 2017 at 5:38 am
Maybe a little bit off track but is there a reason why a COALESCE would be used instead of a CASE statement?
September 29, 2017 at 5:27 am
So, this is how I solved it first of all....
select
September 29, 2017 at 4:22 am
September 28, 2017 at 9:23 am
September 28, 2017 at 8:44 am
I think it is time to build such a site..... 🙂
September 28, 2017 at 8:40 am
I try and do that but most of the time the questions are already answered or the solution is a few jumps away from where I am at the moment.
September 28, 2017 at 8:17 am
September 28, 2017 at 4:42 am
This is why I expressed an interest in using a readable secondary. The data would be available locally for querying.
September 27, 2017 at 9:33 am
I am not sure I would necessarily use a trigger here.but rather a SSRS Report with a summary of the changes made during a period. You could create a subscription...
September 26, 2017 at 10:51 am
Would an ON UPDATE CASCADE be a viable option here?
September 26, 2017 at 10:44 am
I am pretty sure this is the Problem:
[EmailActivityKey] [bigint] IDENTITY(1,1) NOT...
September 26, 2017 at 10:40 am
You might want to examine your full table scans first. There are a couple in there that are really imparing performance.
Once you have done that you could create...
September 26, 2017 at 10:32 am
September 26, 2017 at 10:14 am
Viewing 15 posts - 61 through 75 (of 611 total)