In Mondays Insider newsletter I discussed an email question Id been sent about how to identify the transactions that had rolled back because of a crash, and I said Id blog some code to do it. First of all you need to know the time of the crash. We cant get this exactly (from SQL Server) unless SQL Server [&]

The post Code to show rolled back transactions after a crash appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/F0DXWIBc2H8/

In Mondays Insider newsletter I discussed an email question Id been sent about how to identify the transactions that had rolled back because of a crash, and I said Id blog some code to do it. First of all you need to know the time of the crash. We cant get this exactly (from SQL Server) unless SQL Server [&]

The post Code to show rolled back transactions after a crash appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/PXqyWb6WXQk/

I’ve just released our second set of classes for 2017 for registration! Our classes in July/August will be in Bellevue, WA: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 July 31-August 4 IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 August 7-11 Note that there is a full set of [&]

The post Summer 2017 classes in Bellevue open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/r7VKBZeyGUI/

I’ve just released our second set of classes for 2017 for registration! Our classes in July/August will be in Bellevue, WA: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 July 31-August 4 IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 August 7-11 Note that there is a full set of [&]

The post Summer 2017 classes in Bellevue open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/fJxHvG4K_Hc/

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 125,402: the number of miles I flew on United 34,085: my current tweet total (up 772 from 2015) 13,434: the number of subscribers [&]

The post 2016 review: the year by the numbers appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/jgVeVSis6Uc/

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 125,402: the number of miles I flew on United 34,085: my current tweet total (up 772 from 2015) 13,434: the number of subscribers [&]

The post 2016 review: the year by the numbers appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/j8cG6aVfrmU/

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015) and people have been enjoying it, so here I present the 2016 end-of-year post. I set a moderate goal of 50 books this year but I [&]

The post 2016: the year in books appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/1Xhb6xhf-qQ/

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015) and people have been enjoying it, so here I present the 2016 end-of-year post. I set a moderate goal of 50 books this year but I [&]

The post 2016: the year in books appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/1i7yz0VrlXU/

Glenns latest Pluralsight course has been published – SQL Server: Installing and Configuring SQL Server 2016 – and is just over two hours long. The modules are: Introduction Pre-installation Tasks for the Operating System Pre-installation Tasks for SQL Server 2016 Installing SQL Server 2016 Post-installation Tasks for SQL Server 2016 Automating Common Maintenance Tasks Check it out here. We now [&]

The post New course: Installing and Configuring SQL Server 2016 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/qDd4RoIwFRU/

Glenns latest Pluralsight course has been published – SQL Server: Installing and Configuring SQL Server 2016 – and is just over two hours long. The modules are: Introduction Pre-installation Tasks for the Operating System Pre-installation Tasks for SQL Server 2016 Installing SQL Server 2016 Post-installation Tasks for SQL Server 2016 Automating Common Maintenance Tasks Check it out here. We now [&]

The post New course: Installing and Configuring SQL Server 2016 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/4vrG5V-ffK0/

As we all wind down for the 2016 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your support during 2016, and what better gift than more free content?! As many of you know, I publish a bi-weekly newsletter to more than 13,500 subscribers that [&]

The post SQLskills holiday gift to you: all 2015 Insider videos appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/z1D6KkM_gUw/

Earlier today someone asked on the #sqlhelp Twitter alias if there is a history of database snapshot creation anywhere, apart from scouring the error logs. There isnt, unfortunately, but you can dig around the transaction log of the master database to find some information. When a database snapshot is created, a bunch of entries are [&]

The post Getting a history of database snapshot creation appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/IfAXKV8qb1o/

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to 94 user groups and PASS virtual chapters around the world in 2016! We’d love to present remotely for your user group in 2017, anywhere in the world. It’s not feasible for us to travel to user groups or SQL Saturdays [&]

The post Calling all user group leaders! We want to present for you in 2017! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/OLbJZShTl8c/

This is something that came up recently on the Microsoft Certified Master DL, and is something I discuss in our IEPTO1 class because of the performance implications of it, so I thought it would make an interesting post. Allocation Algorithms The SQL Server Storage Engine (SE) uses two algorithms when allocating extents from files in [&]

The post Investigating the proportional fill algorithm appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/txELcA4VVYM/

This is a quick post to blog a script that allows spinlock statistics to be captured for a defined period of time (as I need to reference it in my next post). Enjoy! Example output (trimmed to fit here):

The post Capturing spinlock statistics for a period of time appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/dS-8q9F1yQU/

As we head into our 8th SQLintersection next month, Im excited to say that its our most diverse, complete, and information-packed show yet! We have 3 precon days at the show and with our postcon day, there are 10 full-day workshops from which to choose. We have SQL keynotes that are relevant and timely, including Microsoft expert Bob Ward and [&]

The post SQLintersection Fall 2016 appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/52uiNiXam5Q/

I’ve just released our first set of classes for 2017 for registration, including a new 3-day class on PowerShell! Our classes in April/May will be in Chicago, IL: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 April 24-28 (US$200 discount for registering in 2016) IESSIS1: Immersion Event on Learning SQL Server Integration Services April [&]

The post Spring 2017 classes in Chicago open for registration appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/X4JKI3ayFDk/

The pages at each level of an index are linked together in a doubly-linked list (using the m_nextPage and m_prevPage fields in their page headers) to allow ascending-order and descending-order scans, based on the index key(s). Data pages in a heap are NOT linked together, as theres no ordering in a heap. However, there is [&]

The post When heap data pages become linked& appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/FbtC808-S7k/

Due to scheduling issues, were not presenting any classes in Europe in 2017 or early 2018, so your last chance to come to one of our classes in Europe is in Dublin next month. Kimberly and I will be teaching our signature IEPTO-1 (formerly IE1) Immersion Event on Performance Tuning and Optimization, in partnership with our great [&]

The post Last chance to see us in Europe until late 2018! appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/SH82pb39pHM/

Glenns latest Pluralsight course has been published – SQL Server: Improving Storage Subsystem Performance – and is just over two hours long. It’s based on Glenns very popular user group/conference sessions and workshops, plus extensive work with SQLskills consulting clients and in his previous roles. The modules are: Introduction Measuring and Analyzing Storage Subsystem Performance Testing and Benchmarking Storage Subsystems Understanding Storage [&]

The post New course: Improving Storage Subsystem Performance appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/DK6aN4XMhMM/