Reindex Procedure with a Twist (or two)

We’ve all seen reindex procedures that rebuild all indexes in a database or all indexes in a database which have less than a specified ScanDensity. This one goes a few steps further. First, the DBA can specify a ScanDensity_Threshold (a min value for ScanDensity), plus a Limit (qty or %). If you specify a ScanDensity_Threshold […]

5 (1)

2005-04-20 (first published: )

1,819 reads

Julian and Gregorian Conversion Functions

After seeing a thread in the forums about converting a Julian date to Gregorian, I decided to write these functions. There are two functions in the script, getJulian and getGregorian. getJulian accepts a datetime parameter and returns the Julian date as an integer. getGregorian accepts an integer and returns the Gregorian date as datetime. A […]

2004-10-18 (first published: )

528 reads

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Trying to create Nested SUM OVER Function for backwards running total.

By RocksteadyDev

Here is sample code from my running total, now I need to reverse it...

Copy or Move Shapshot Reports

By les.61

Hi We have snapshots on an old report that we would like to move...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The typo

See possible answers