External Article

T-SQL Function to Determine Holidays in SQL Server

While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.

SQLServerCentral Article

Bookmark Lookups

Building high performance applications with SQL Server can be a challenge if you do not understand how the query processor works and how the server uses indexes. SQL Server expert Randy Dyess brings a look at how bookmark lookups are used when satisfying a query and how this can impact the performance of your query.

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

Alamat BCA KCP Pluit Raya 082225313145 WA CS

By Layanan_24jam

WhatsApp 082225313145 Jl. Pluit Raya No.200, RT.16/RW.8, Penjaringan, Kecamatan Penjaringan, Jkt Utara, Daerah Khusus...

When the Token Meter is Zero

By dbakevlar

Comments posted to this topic are about the item When the Token Meter is...

Understanding Temp Tables and Table Variables in SQL Server

By sabyda

Comments posted to this topic are about the item Understanding Temp Tables and Table...

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers