SQL Performance

MARCH 17, 2020

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. Not everyone will be able to move to column store storage quickly, and it won't always be the right solution anyway.

Servers 86

Servers Tuning Database Efficiency 86

All Things Distributed

MARCH 24, 2011

The images from the 2008 TNW Conference have travelled around the world in my Animoto demo: This year TNW is showing that it is not just a conference for talkers but also for builders by organizing a massive Hackaton in the two days running up to the conference. Driving Storage Costs Down for AWS Customers. Syndication. or rss feed.

AWS 96

AWS Internet Internet Storage 96

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55

Servers Azure Hardware Network 55

All Things Distributed

APRIL 5, 2012

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Ã?

Innovation 149

Innovation AWS Education Network 149

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. Because of this, I think they will be a great choice for virtualization hosts and for Storage Spaces Direct nodes. This processor family has enough compute horsepower, memory bandwidth and capacity, and I/O bandwidth to support large server workloads on a single-socket server.

Servers 52

Servers Benchmarking Virtualization Architecture 52

SQL Performance

MAY 16, 2019

The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. The calculated row size (61 bytes) differs from the true row storage size (60 bytes) by the extra one byte of internal metadata present in the insert stream.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The test table schema is such that 130 rows can fit on a single 8KB page when row versioning is off for the database. We must also remember the final storage engine test for at least 100 rows: I >= 100. I >= 100.

Cache 64

Cache Testing Servers Code 64

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 11, 2020

​​​​ Note:​​ The BID/SNI ​​ Trace for the ​​ SQL Server (SQL 2008’ish ​​ days) used to require ETW setup and a restart of SQL Server.

Network 40

Network Servers Processing Software Engineering 40

All Things Distributed

APRIL 19, 2010

Here are the laurels given by the editors: Debuting in November 2008, Amazons entry into the CDN market quickly became a major player. Driving Storage Costs Down for AWS Customers. Expanding the Cloud - The AWS Storage Gateway. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications.

Media 61

Media AWS Storage Big Data 61