SQLDownSouth

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

Deadlock - What to do next?

By krypto69

Hi, I have a job that keeps getting a deadlock victim error and  fails....

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

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers