If you graph computer/query cost against the size of data, you can get four quadrants: <ol> <li>small data, small compute (most CRUD app queries)</li> <li>small data, big compute (complex BI queries for this quarter, most reporting)</li> <li>big data, small compute (logs, audit data)</li> <li>big data, big compute (complex BI queries across all our data)</li> </ol> Read the rest of <a href= "https://www.sqlservercentral.com/editorials/dont-let-corner-cases-drive-your-design"> Don't Let Corner Cases Drive Your Design</a>

If you graph computer/query cost against the size of data, you can get four quadrants: small data, small compute (most CRUD app queries) small data, big compute (complex BI queries for this quarter, most reporting) big data, small compute (logs, audit data) big data, big compute (complex BI queries across all our data) Read the rest of Don't Let Corner Cases Drive Your Design

If you graph computer/query cost against the size of data, you can get four quadrants: <ol> <li>small data, small compute (most CRUD app queries)</li> <li>small data, big compute (complex BI queries for this quarter, most reporting)</li> <li>big data, small compute (logs, audit data)</li> <li>big data, big compute (complex BI queries across all our data)</li> </ol> Read the rest of <a href="https://www.sqlservercentral.com/editorials/dont-let-corner-cases-drive-your-design" rel="noopener noreferrer"> Don't Let Corner Cases Drive Your Design</a>

Don't Let Corner Cases Drive Your Design

A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.

Share Don't Let Corner Cases Drive Your Design

Sign up to save your podcasts

Don't Let Corner Cases Drive Your Design

Don't Let Corner Cases Drive Your Design

More shows like Voice of the DBA

The Real Python Podcast