Category: Advanced

Scale-out SSRS (a brain dump)

Post author By Jen McCown
Post date February 6, 2018
Categories In Admin, Advanced, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on Scale-out SSRS (a brain dump)

So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went well, but there were a couple of hiccups I’d like to record before they fly out of my head again. Note, too, that I am NOT an SSRS guru. Feel free to ping me in the comments […]

The #TSQL2sday #70 roundup

Post author By Jen McCown
Post date September 10, 2015
Categories In Admin, Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully. Here we go. Rob Farley : Superhero powers for managing the enterprise. Rob talks about what his consulting company looks for when talking to a customer. Specifically, things that are out of the ordinary. And of […]

Why don’t they make the optimizer faster? (An essay on nested views)

Post author By Jen McCown
Post date October 1, 2014
Categories In Advanced, Intermediate, sql server, sqlserverpedia-syndication, Tech and Learning
5 Comments on Why don’t they make the optimizer faster? (An essay on nested views)

We got a question recently that basically boiled down to this: Nested views shouldn’t be such a performance suck. Why doesn’t Microsoft make the optimizer deal with nested views better? We’ve looked into this a good deal – nested views are one of my pet peeves, and I’ve blogged about it at least a couple of times (see Detangling Nested Views and […]