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,893 reads

Blogs

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Advice I Like: Transactions and Relationships

By

Life gets better as you replace transactions with relationships. – from Excellent Advice for...

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Read the latest Blogs

Forums

Limits, Not Goals

By Grant Fritchey

Comments posted to this topic are about the item Limits, Not Goals

Making Additions and Changes; Getting Error Preventing Them

By Ahr Aitch

MS SQL Server/SSMS are my tools. As my project evolves I find I need...

SSL Certificate Chain

By suchit.d@promantia.com

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, length, and scale for an int variable?

See possible answers