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,758 reads
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,758 reads
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
558 reads
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
492 reads
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,512 reads
Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of...
2015-06-25
671 reads
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
565 reads
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,060 reads
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,419 reads
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
626 reads
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,401 reads
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Comments posted to this topic are about the item A Challenge of Our Knowledge
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Comments posted to this topic are about the item Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers