Skip to content
Born SQL

Primary Menu

  • Home
    • About
    • Contact Us
  • Hire me!
    • SQL Server Performance and Health Check (dbSnitch)
    • Upgrade Wizard
    • Disaster Recovery
    • 2-Day Tune-Up
    • DBA
    • Speaking
  • Resources
    • SQL 2000: Duplicate Index Finder
    • Database Backup Sync and Restore
    • Max Server Memory Matrix
    • SQL to Excel Exporter tool
    • Blog series links
  • Blog
  • IT documentation

Tag: nested views

Why nested views are bad

Posted on 14 February 201813 February 2018 by randolph

Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you tend to use all over the place (a very common practice when checking user permissions). There are five base tables in the join, but it’s fast enough. Instead of copying
-> Continue reading Why nested views are bad

Tagged design, nested views, Performance, T-SQL 3 Comments

Posts navigation

Randolph West

Randolph West

Randolph West (they/them) is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, you can see them acting on the stage and screen, or doing voices for independent video games. Also available for mentoring, talks on SQL Server and technology in general, Randolph offers training for junior DBAs. Connect with Randolph on Twitter. Buy their books on Amazon.

View Full Profile →

Recent Posts

  • Calgary Data User Group with Deborah Melkin and Andy Yun
  • T-SQL Tuesday Retrospective #013: What the business wants
  • Upcoming speaking engagements
  • Zeroing out a transaction log file does not use zeroes
  • What is a community advisory board anyway?
  • T-SQL Tuesday Retrospective #012: Why DBA skills are necessary
  • T-SQL Tuesday Retrospective #011: Misconceptions
  • Which configuration changes in SQL Server require a restart?
  • Welcome to the Azure Data Community, empowered by Microsoft
  • Calgary Data User Group – 24 February 2021 at 5pm MST

Follow @BornSQL on Twitter

Follow @_randolph_west on Twitter

Archives

Popular Tags

Azure Azure SQL Database Backup Backups Beginner Careers Cloud Community Compatibility Configuration Corruption Data Recovery data types date datetime datetime2 Development DevOps Disaster Recovery Fundamentals Internals Linux Maintenance Max Server Memory Migration PASS Summit Performance Recovery Security SQLNewBlogger SQL PASS SQLSaturday SQL Server SQL Server 2000 SQL Server 2016 SQL Server 2017 SQL Server 2019 SQL Server on Linux SSMS Storage Engine T-SQL T-SQL Tuesday Temporal Tables tsql2sday Upgrade
Calgary, Canada
info@bornsql.ca
+1-587-997-4845
  • Twitter link
  • Linkedin link

Copyright © Born SQL, a 1690406 Alberta Ltd company

This site uses cookies: Find out more.