You can set up a load balancer to handle the networking part. SQL Server doesn't handle IP redirection. If the application is using IP to connect, that's a fundamental problem....

Everybody can shift work around if a system is down, and they have. However, there's a cost. The reason we try to build systems that can run with hot patches...

Those are good tools, but are you asking about tools to see the plan, or how to understand it quickly?

Ah, you're right, Drew. I was thinking this was a code replacement that would leave the WHERE, but that would work. However, it's also a PR to upstream modules, not...

I would urge you to product a real result set, which can be with inserts into another table. This will help you be sure you've correctly identified things and make...

Be good to see what you mean by grouping. Show some results. FWIW, this is why testing is a good way to get set up for queries: https://www.sqlservercentral.com/articles/using-tsqlt-tests-to-practice-queries

That's the view of someone that sees these systems serving a few humans. These days systems serve other systems, humans around the world, and they can be live 24x7 for...

I've run into people that were sure you couldn't index unless this was persisted.

Fair point, and I'll reword.

This does change some parameterization stuff, but I think it prevents simple mode, which I'm not sure would be used here. Not sure, and haven't dug into this as other...

Good catch. Updated question

Your last sentence doesn't quite make sense. You can just let the output come back and use redirects >>, to put the data into a file.

SQL Server doesn't track much by default. There is data in the DMVs, but all monitoring tools do is read this, aggregate, store, and manage data retention. If you don't...

Looks I'm gonna lose. Forgot to check the lineup, and now need a new kicker. Not that that mattered.

SQL Sat Memphis this weekend as well. Lot of fun and enjoyed my trip.

https://www.sqlsaturday.com/870/Sessions/Schedule.aspx