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

Archives: July 2013

Page Split Mini-Series - Part II - Page Latch Contention

Last time, in Part I of my page-split mini-series, we began speaking about page splits, defining what they are, how they occur, and which counter we can use to track them.

This time we will talk a little about how they show up as a resource wait, and how we… Read more

0 comments, 11,009 reads

Posted in Pearl Knows on 26 July 2013

Tonight: NYC UG Presents: Replication vs. Always-On with Meir Dudai

TODAY, JULY 25: the NYC SQL Server User Group is honored to have a visiting SQL Server MVP all the way from Israel. They will be meeting Thursday evening on the 25th at 6:00 PM at the Microsoft Offices on the 6th floor of 1290 6th Avenue. There will be… Read more

0 comments, 1,219 reads

Posted in Pearl Knows on 25 July 2013

SQLSaturday#235 NYC - The Schedule You All Have Been Waiting For!

Late last night in the Halls of Congress, a grand gathering of planners took place to form that which we waited for many a days. Never the perfect finished work, but a living document that is subject to popular change. In the smoky chambers of shadowy figures, the pressure was…

Read more

0 comments, 1,697 reads

Posted in Pearl Knows on 18 July 2013

Upcoming Local NJ Events! Presenting Martin Schoombee and Allan Hirt

Just a quick word on some local events coming your way in the New Jersey area! 

TOMORROW - The NJSQL user group presents Martin Schoombee.  No, this is not a biblical meeting about Moses, but Martin brings us The 10 Commandments of ETL.  There were originally 15, but the… Read more

0 comments, 948 reads

Posted in Pearl Knows on 15 July 2013

T-SQL Tuesday #44 - Second Chances


So, it’s Tuesday and its that time again for T-SQL Tuesday.  We’re at the 44th entry which means it’s been about 3.7 years since this blog party began, by SQL MVP extraordinaire, Adam Machanic (@AdamMachanic| Blog).  I guess us SQL People can’t stop… Read more

1 comments, 1,808 reads

Posted in Pearl Knows on 9 July 2013

A Page-Splitting Headache - Page Split Mini-Series

Page splits are a normal occurring process in an OLTP system.  However, too many page splits can cause performance issues that will slow down your system.  From my recent adventures in the field, I want to share some of my research and tips that can hopefully help you with your… Read more

1 comments, 8,440 reads

Posted in Pearl Knows on 8 July 2013