Remove 2008 Remove Database Remove Hardware Remove Speed
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
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ƃ?

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

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

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46
article thumbnail

AMD EPYC 7002 Series Processors and SQL Server

SQL Performance

Single-Socket Database Servers. It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). Higher memory speed and bandwidth. I/O lanes. Single-threaded CPU performance is the one relative weak point of the AMD EPYC 7742 processor.

Servers 52