article thumbnail

Get details of SQL Server Database Growth and Shrink Events

SQL Shack

It is essential for the DBA to need to ensure the SQL Server database performance. Performance tuning is an open-ended task, and you need to ensure the monitoring of various database parameters.

article thumbnail

What Adrian Did Next?—?Part 3?—?eBay?—?2004 to 2007

Adrian Cockcroft

Their database model later become known as NoSQL, although it was implemented on top of Oracle, each database held one table and indexes, and there were many sharded Oracle databases for each data set so it could be scaled horizontally as well.

Google 52
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

ChatGPT, Author of The Quixote

O'Reilly

It takes the prompt and just returns one of the most similar “training documents” it has in its database, verbatim. In “ How Photos of Your Kids Are Powering Surveillance Technology ,” The New York Times reported that One day in 2005, a mother in Evanston, Ill., At the other end of the extreme consider a search engine.

article thumbnail

Simple Parameterization and Trivial Plans — Part 2

SQL Performance

For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. Database compatibility is set to 150, and the cost threshold for parallelism is set to 50 to avoid parallelism for now: ALTER DATABASE SCOPED CONFIGURATION. I’ll cover the reasons for the guessing later in the series.

Cache 90
article thumbnail

Back-to-Basics Weekend Reading - A Decomposition Storage Model

All Things Distributed

Traditionally records in a database were stored as such: the data in a row was stored together for easy and fast retrieval. Combined with the rise of data warehouse workloads, where there is often significant redundancy in the values stored in columns, and database models based on column oriented storage took off.

Storage 90
article thumbnail

Performance Tuning Re-indexing and Update Statistics – A Case Study

SQL Server Performance

Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.

Tuning 40
article thumbnail

Deprecated features to take out of your toolbox – Part 3

SQL Performance

These types are on the deprecated list for many reasons, and have held a permanent spot on that list since being replaced by the max types way back in SQL Server 2005. Let's create a simple database with a few tables: CREATE DATABASE BadIdeas ; GO. USE BadIdeas ; GO. CREATE TABLE dbo. [ object_id ] WHERE p.

C++ 58