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)

2018-02-09 (first published: )

10,350 reads

Blogs

Default event_file path for Extended Events

By

Foreword Have you ever wondered where the .xel file is saved when you create a...

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Read the latest Blogs

Forums

Restore data for a single tenant in a multi tenant DB

By askcoffman

Our OLTP is being converted from a one tenant per database structure to a...

average of percentage

By sqlenthu 89358

Hello, I am looking to get average of percentages (to be calculated in same...

Multiple reports generation

By sahoong

Hello Guys, Could someone please, help me with this issue that I am having?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers