Technical Article

INF: Understanding How to Configure a SQL Server Connection Affinity

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.

SQLServerCentral Article

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

Blogs

Denver Dev Day Oct 2024 Slides

By

Here are the slides from my talk today: CI in Azure DevOps If you...

Should I Learn PostgreSQL

By

I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...

A New Word: Hickering

By

hickering – n.  the habit of falling hard for whatever pretty new acquaintance happens...

Read the latest Blogs

Forums

Converting Non Numeric to Null

By yrstruly

I have a numeric column called "Value" in a flat file, which contains both...

Converting Non Numeric to Null

By yrstruly

I have a numeric column called "Value" in a flat file, which contains both...

Are We Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Are We Dinosaurs?

Visit the forum

Question of the Day

Code Blocks

What happens with this code: 

DECLARE @Iteration INT = 0;

WHILE @Iteration < 10
    SELECT CustomerName,
        CustomerStatus
    FROM dbo.Customer
    WHERE CustomerID > 3;

    SET @Iteration += 1;

See possible answers