Viewing 15 posts - 13,426 through 13,440 (of 59,063 total)
Could it be simple blocking of table resources since more than one job is running?
December 10, 2017 at 11:38 pm
December 10, 2017 at 11:27 pm
December 10, 2017 at 10:34 pm
I'm with Steve. I love "Helper Tables" because you can change their content instead of changing code. If it were my task, here's the table that I'd build.
December 10, 2017 at 10:10 pm
p.s. Here's hoping that you really are using SQL Server 2014. IIF came out with 2012 and it resolves to CASE operators behind the scenes but it sure does simplify...
December 10, 2017 at 8:12 pm
Shifting gears and perhaps I'm over-anticipating/over-engineering , but it looks a bit like someone is trying to do a workload analysis. If that's the case, let's look into a bit...
December 10, 2017 at 8:04 pm
Thank you, thank you, thank you!
That's just perfect and absolutely what I needed and...
December 10, 2017 at 6:09 pm
December 10, 2017 at 5:31 pm
December 10, 2017 at 4:55 pm
December 10, 2017 at 4:19 pm
December 10, 2017 at 3:38 pm
My tables are partitioned on business date. My requirement is to add 365 partitions for...
December 10, 2017 at 2:44 pm
Awesome thinking outside the box! Well done!
December 10, 2017 at 2:38 pm
Thx for the suggestions.
am on SQL 2016.
have got a working solution...
December 9, 2017 at 10:34 pm
Viewing 15 posts - 13,426 through 13,440 (of 59,063 total)