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 […]

5 (4)

You rated this post out of 5. Change rating

2023-09-22

1,395 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 (3)

You rated this post out of 5. Change rating

2023-08-07

4,154 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Error message in launching web service url in sql report server

By Teewhy

I am getting the following error when I launch web service url in sql...

Report server login issue

By Teewhy

Trying to deploy reports in visual studio 2022, reporting service login is asking for...

Opening and closing with date filter is not giving me correctly output

By akhterhussain80

I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers