SQLServerCentral Article

Manage Your Business Rules in T-SQL Query

  • Article

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

4 (1)


8,949 reads

SQLServerCentral Article

T-SQL Language Changes in SQL Server 2022

  • Article

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

5 (11)


17,428 reads


Daily Coping 23 Sep 2022


Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?


Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022


Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs


Couldn't allocate new page for database alert even the Database has free space

By ramana3327

Hi, We have a database. We received the alert Could not allocate new page...

Best Approach to move the databases in Always On

By ramana3327

Hi, We have Always on Server with one primary & 1 secondary ( Not...

Help with SQL

By don075

I need to display 1 or 0 for the first occurrence of a certain...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers