What is a model database?


Do you ever take a look at SSMS in the System Databases section? People...

Daily Coping 26 Jan 2021


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

Rowcount estimates when there are no Statistics


When you don't have statistics, what does SQL use to calculate the estimated number...

Read the latest Blogs


need help with T-sql

By aureliu

Hello my dears,   Please help with the query to retrieve  the data as...

REPLACE 2 lines CR+LF by 1 line CR+LF

By ddperso

In a table, I have a field (text format) which contains sometimes 2 or...

Balance is not calculating correctly,when date get change in transection.

By akhterhussain80

Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers