Are you partitioning in order to take advantage of the data management aspects of partitioning (rolling windows, that sort of thing) or are you attempting to partition for performance. If...

I don't know of a video along the lines of what you're looking for. However, I can make one huge recommendation. Learn Query Store. It's your best friend in the...

I have examples in my book.

It's actually hard to get these things. You won't see them very often, The optimizer almost seems to have a bias against...

The Cumulative Updates are cumulative. So you only need to install the SP2 and the latest CU.

Looping a procedure like that (which is possible, look up a WHILE loop), will lead to all sorts of problems. I wouldn't recommend it at all. Instead, from what you're...

Just starting out, stick as much as possible to straight T-SQL. Then, as you start to see odd bits of behavior or weird requirements or odd structures, you can start...

I've had this discussion with a lot of people, MCMs, MVPs, consultants and gurus. The general consensus is pretty straight forward. If you're not experiencing I/O waits and bottlenecks, leave...