External Article

SQL Server 2000 User-Defined Functions White Paper

The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.

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

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Data is not immutable

By

Information — in the form of data — usually stored as binary 1s and...

Read the latest Blogs

Forums

Print sql server substring from a table column and put into a table

By SQL_Hunt

Hello, Looking for a guidance to form a script to extract a specific substring...

Backup by specified date interval

By lucasomoura

Good afternoon, Consulting the SQL Server documentation I saw that there are some types...

Selecting distinct values from dupes based on latest date

By DaveBriCam

I have a table of patients that has often multiple occurrences of a patient...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers