Igor Micev

Integration specialist, Developer & Programmer, Database administrator, and Architect with 15+ years of
expertise. Experienced in software development, database analysis & design, performance tuning, upgrades &
migrations, high availability solutions implementation, and design, backup and recovery strategies, and system
capacity planning.

SQLServerCentral Article

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.

4.47 (47)

You rated this post out of 5. Change rating

2018-02-09 (first published: )

10,775 reads

Blogs

The Annual SQL Saturday in Baton Rouge

By

I’ve been to quite a few of the SQL Saturday Baton Rouge events. There...

25 Years of Redgate

By

I’m in Austin today, ready for the Redgate Software 25th Birthday celebration. The company...

Read the latest Blogs

Forums

Summarize the proportions stored in the table

By us26

CREATE TABLE dbo.tab1 ( idrow INT NOT null IDENTITY, group1 VARCHAR(10) NOT NULL, c1...

SSIS execute powershell fails with exit code 1

By isaac_654135

I'm trying to execute a simple, test powershell script (which works fine when I...

Developer Edition

By Bruin

If you have Developer 2022 installed can you connect from your desktop version of...

Visit the forum

Question of the Day

Query Store for DDL

How do I configure Query Store to capture plans for CREATE and ALTER DDL commands in SQL Server 2022?

See possible answers