Database Design

SQLServerCentral Article

How Would You Design This: Scheduling Classes

  • Article

One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for a system but might require more effort work from developers to write queries. Many […]

4.83 (6)

You rated this post 5 out of 5. Change rating

2023-09-22

2,206 reads

SQLServerCentral Article

Combine DATE and TIME to DATETIME2 in SQL Server

  • Article

The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".

5 (4)

You rated this post out of 5. Change rating

2023-08-07

21,595 reads

Blogs

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

By

As data becomes the backbone of modern business, understanding how to manage and analyze...

Simplify Kubernetes Security With Kyverno and OPA Gatekeeper

By

Here’s how these tools can make Kubernetes security easier and help you avoid common...

Read the latest Blogs

Forums

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Using Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using Heaps

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers