SQL Server 2017

External Article

Resumable Online Index Create and Rebuild Operations

  • Article

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

2019-03-21

1,738 reads

External Article

How Big is Your Transaction Log?

  • Article

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.

2018-11-06

3,724 reads

Blogs

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

The Last Trip of 2022

By

It’s the last trip for me today. I head to the UK for a...

How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers

By

This article describes the steps you take to prepare the VMware infrastructure for installing...

Read the latest Blogs

Forums

Get Date Monday Show results for weekend and then else 24 hours

By DMcMorris@welcom.co.uk

Hi,   I have a SQL query below in which i need to be...

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

ASP.NET website force different windows authenticated user

By Raja mssql

Hi All, We are deploying website by using windows authenticated user. It is default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers