-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Matan Yungman

Matan Yungman is a Technical Evangelist and senior consultant at Madeira SQL Server Services. His job is to get the word out about SQL Server. He speaks, lectures, writes, teaches and consults about SQL Server, focusing mainly on performance tuning, database development, high availability and database design. He’s passionate about SQL Server, technology and the SQL Server community.

Archives: June 2015

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 fun taking part in such a special event.

The slide deck and scripts I used in the session can be downloaded here.

The post 24 Hours of PASS:… Read more

0 comments, 504 reads

Posted in Matan Yungman on 25 June 2015

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 there.

24 Hours of PASS is a virtual event of 24 consecutive hourly sessions of speakers from all over the world. The theme this time is “growing our community”, and… Read more

0 comments, 491 reads

Posted in Matan Yungman on 18 June 2015

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 too small?

Imagine you have a very small table (up to a few thousand rows) that fits into a single SQL Server page, being constantly read and updated, and… Read more

1 comments, 2,914 reads

Posted in Matan Yungman on 16 June 2015

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 @i INT = 1
WHILE @i <= 100000
BEGIN
	INSERT LoadMeFast SELECT @i, GETDATE(), REPLICATE(N'ABCD', 25)
	SET @i+=1
END
GO

The script runs for… Read more

10 comments, 3,890 reads

Posted in Matan Yungman on 3 June 2015