article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. With proper database management, it’s possible to cut your bills in half.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. Test Environment. BountyAmount.

Servers 86
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Customer Conversations - How Intuit and Edmodo Innovate using.

All Things Distributed

One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. Amazon RDS removes the headaches of running a relational database service reliably at scale, allowing Amazon RDS customers to focus on innovation for their customers. hands freeƃ?

article thumbnail

How architecture evolves into strategy

O'Reilly Software

In 2008 or so, when data scientist emerged as a job title, it was widely ridiculed as a nonjob: the thought that people who just worked with data could be scientists, or employ the rigors of their time-honored methods, was literally laughable in many circles. Improve time to market/speed of operations. Machiavelli, The Art of War.

Strategy 100
article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49
article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. So far, we don't know the official base and turbo clock speeds, but there was a recent leak of partial specifications and pricing by a European retailer that listed max boost clock speeds of up to 3.4

Servers 46
article thumbnail

AMD EPYC 7002 Series Processors and SQL Server

SQL Performance

Single-Socket Database Servers. Higher memory speed and bandwidth. AMD's biggest challenge is going to be convincing customers to actually buy AMD-platform servers, since Intel has been so dominant in the server market since the Nehalem architecture era back in 2008. Higher memory density/capacity. Lower power usage.

Servers 52