---

Filter by type:

• All
• Blog Posts

How to Measure IO Latency for Database Files in SQL Server

• by Matan_Yungman

• Matan Yungman

In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a...

2015-04-08

1,209 reads

Can Log Shipping Work Without Shipping the Log?

• by Matan_Yungman

• Matan Yungman

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...

2015-04-02 (first published: 2015-03-30)

6,880 reads

SQLRally and SQLBits Slides and Demos

• by Matan_Yungman

• Matan Yungman

It’s been a great a busy week.
On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally...

2015-03-06

581 reads

How to Fix Latch Problems when Working with Ascending Keys in SQL Server

• by Matan_Yungman

• Matan Yungman

Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...

2015-03-03

652 reads

Speaking at SQLBits and SQLRally

• by Matan_Yungman

• Matan Yungman

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...

2015-02-24

441 reads

The Data Loading Performance Presentation

• by Matan_Yungman

• Matan Yungman

This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.
I worked on the session a...

2015-01-21

539 reads

What to Expect When Transitioning from DBA to Consultant

• by Matan_Yungman

• Matan Yungman

Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...

2015-01-15

536 reads

Things I Learned in 2014

• by Matan_Yungman

• Matan Yungman

2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...

2015-01-06

751 reads

Rebuilding and Reorganizing Clustered Columnstore Indexes

• by Matan_Yungman

• Matan Yungman

Clustered Columnstore Indexes, as well as “regular” indexes, support the Rebuild and Reorganize operations. However, the meaning of those operations...

2014-12-16 (first published: 2014-12-11)

5,990 reads

Tracking Progress of SQL Server Index Builds and Rebuilds

• by Matan_Yungman

• Matan Yungman

Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when...

2014-11-11 (first published: 2014-11-06)

7,622 reads

Filter by type:

• All
• Blog Posts