SQLServerCentral Editorial

Model Good Behavior

I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]


sp_GetRowcount: How to count the number of rows in any SQL Server table fast


Have you ever had to find the number of rows in a user table,...

Webinar with Pavilion Data 2022.02.09


Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion...

VS Live Cancelled


I got a note this week from the organizers of VS Live. They let...

Read the latest Blogs


Stored Procedure Error

By water490

Hi I am creating stored procedure for the first time.  I am getting error:...

Run SQL Query in C#

By water490

Hi I am working with SSIS to automate data collection.  I need to make...

configure SSRS using powershell

By Dan

Dear all, I am seeing an issue with configuring SSRS When I am trying...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers