December 2018: Partitioned views by Rick Lowe
Why should I care about ... partitioned views by Rick Lowe (@DataFLowe)
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren’t on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1.
About Rick:
Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more focused on operational and performance issues than code.
Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
-
2:00:47
Los Angeles Data Platform
1 year agoOCT 2022 - Tame Your Unruly Data With Constraints by Rob Volk (@sql_r)
8 -
6:08
Grover Park George On Access
8 months agoLeverage SQL Server Views in PowerApps
16 -
16:13
tomerbd
3 years agoSQL Window Functions (OVER, PARTITION BY)
1 -
18:20
About Programming Code
11 months agoSQL GROUP BY Statement: Mastering Data Grouping in SQL
7 -
18:07
IPGraySpace
3 years agoIPGraySpace: SQL Server - How to create stored procedure in SQL Server with commit and rollback
561 -
10:21
Alarm Grid Home Security DIY Videos
5 years agoHow to Switch Partitions on a Honeywell Vista System
1 -
0:46
officepartitioningsydney
1 year agoOffice Partitioning Sydney Australia | Office Partitions Sydney Australia ☎ 0418970556
37 -
11:02
Pharos Technology
11 months agoUnderstanding SQL Fundamentals in Microsoft Access
4 -
11:43
TechWithMartin
1 year ago $0.01 earnedMaster SQL for Beginners-How to Create Database(Part 2)
89 -
1:01:30
Magna Data
1 year agoIntroduction to Microsoft Azure Purview
4