datediff

Blogs

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)

By

Welcome to a new year, and a new look at what I’ve learned in...

Azure SQL vCore vs DTU

By

If you are building database solutions in Azure , using Azure SQL Database then...

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Read the latest Blogs

Forums

XML Vs Non-XML

By IT researcher

I am using SQL Server 2008 R2. While using XML data type and  XQuery...

Staging or UAT Environment

By VastSQL

Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...

Transaction was deadlocked on lock resources with another process

By L_Goyal

I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers