Technical Article

Business Time in Seconds Function

SQL Function to calculate number of business seconds between 2 datetime fields. Input Parameters: @startdate - Start Time (datatype DateTime) @enddate - End Time (datatype DateTime) @starthour - Start of Business Day (datatype DateTime) (Format: '1900-01-01 9:00:00') @endhour - End of Business Day (datatype DateTime) (Format: '1900-01-01 17:00:00') @workdays - Business Day string - Use […]

2006-03-15 (first published: )

234 reads

Blogs

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

Daily Coping 28 Nov 2022

By

Today’s coping tip is to broaden your perspective: read a different source of media....

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Read the latest Blogs

Forums

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

Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers