Database

Cyber Monday for Data Models Just in case you've been head-down into your data models for too long, in the US the Friday after Thanksgiving is called Black Friday. Traditionally this is a day for massive sales and steep discounts to ensure that Americans start their holiday shopping with gusto.  Over the years, Black Friday has been creeping earlier and earlier in the week and now starts on Thursday for some of the most desperate shoppers. These originally were brick and mortar store sales, but these days Black Friday ...

Posted by on in Database Administration
Embarcadero® DBArtisan® 2016 Embarcadero® DBArtisan® 2016 is a revolutionary, team-enabled database administration solution using integrated performance analytics and team sharing capabilities to maximize availability, performance, security and collaboration across multiple DBMSs. DBArtisan is the essential DBA toolset to dramatically lower costs and save time by leveraging performance insights to identify issues and pinpoint resolutions. DB Team Server (Included) Work Smarter. Get Team-Enabled. With DBA teams struggli...
ER/Studio Model Repository Database Sizing Guide for IBM DB2 Howdy! In this final installment, I will be covering on how to ensure optimum model repository performance for IBM DB2. [Update Statistics] RUNSTATS command Updates statistics in the system catalog about the characteristics of a table and/or associated indexes, or statistical views. These characteristics include number of records, number of pages, and average record length. The optimizer uses these statistics when determining access paths to the data. Collect statistics on the table ...
ER/Studio Model Repository Database Sizing Guide for Oracle Howdy!  In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model Repository. In today's blog post, I will be showing on how to update table statistics on the ERSRepo Schema for an Oracle database/schema. [Tip 1] It is highly recommended to create a schema for the ER/Studio Model Repository. [Gather Statistics in Oracle] exec dbms_stats.gather_schema_stats( -ownname          => ...
ER/Studio Database Sizing Guide - Best Practices ER/Studio Database Sizing Guide - Best Practices Howdy! In this blog post, let us shed some light on how to better leverage Capacity planning and Database Sizing for ER/Studio's Repository Database. I will be covering each individual Database Platform per blog post. In today's series, I will be covering Microsoft SQL Server: For Microsoft SQL Server Database:  Perform the following steps: After approx a month or so of repository activity,  1) Run sp_updatestats to update table ...

Check out more tips and tricks in this development video: