---

Filter by type:

• All
• Blog Posts

Indexes on GUIDs – Not Only Fragmentation

• by Matan_Yungman

• Matan Yungman

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,724 reads

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

• by Matan_Yungman

• Matan Yungman

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

541 reads

Speaking about Columnstore Indexes at PASS Performance Palooza

• by Matan_Yungman

• Matan Yungman

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

467 reads

Can a SQL Server Table be Too Small?

• by Matan_Yungman

• Matan Yungman

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,376 reads

24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

• by Matan_Yungman

• Matan Yungman

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation.
It was a lot of...

2015-06-25

645 reads

Speaking at 24 Hours of PASS: Growing Our Community

• by Matan_Yungman

• Matan Yungman

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

545 reads

The #1 Enemy of Data Loading in SQL Server

• by Matan_Yungman

• Matan Yungman

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,043 reads

Query Progress Tracking in SQL Server for the DBA VC

• by Matan_Yungman

• Matan Yungman

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,396 reads

How to Find Objects that Contain a Certain String in SQL Server

• by Matan_Yungman

• Matan Yungman

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

485 reads

Make Sure to Schedule Your SQL Server Replication Jobs

• by Matan_Yungman

• Matan Yungman

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,210 reads

Filter by type:

• All
• Blog Posts