Indexes on GUIDs – Not Only Fragmentation
A client called us with the following issue:
He had a table of a few dozen million rows. The table had...
2015-08-03 (first published: 2015-07-27)
2,743 reads
Columnstore Indexes at PASS Performance Palooza: Recording and Materials
Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The...
2015-07-24
548 reads
Speaking about Columnstore Indexes at PASS Performance Palooza
The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance...
2015-07-21
483 reads
Can a SQL Server Table be Too Small?
Everyone’s talking about “Big Data”, huge tables and data explosion right?
Can we have a problem of a table that is...
2015-06-26 (first published: 2015-06-16)
3,508 reads
24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts
Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of...
2015-06-25
662 reads
Speaking at 24 Hours of PASS: Growing Our Community
24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking...
2015-06-18
552 reads
The #1 Enemy of Data Loading in SQL Server
Let’s look at the following script:
CREATE TABLE LoadMeFast (Id INT NOT NULL,
InsertDate DATETIME NOT NULL,
ABunchOfLetters NVARCHAR(100)
)
GO
SET NOCOUNT ON
GO
DECLARE...
2015-06-09 (first published: 2015-06-03)
4,056 reads
Query Progress Tracking in SQL Server for the DBA VC
This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...
2015-05-29
1,417 reads
How to Find Objects that Contain a Certain String in SQL Server
Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t...
2015-05-13
620 reads
Make Sure to Schedule Your SQL Server Replication Jobs
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
Right? Wrong..
At...
2015-05-04 (first published: 2015-04-22)
5,387 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers