Igor Micev

I'm a passionate SQL Server professional with 10+ years of experience with databases. Developer, Administrator and Architect with 10+ years of expertise in data analysis, design, programming, performance tuning, upgrades, migrations, high availability solutions implementation, backup & recovery strategies and database capacity planning expertise.

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: )

9,722 reads

Blogs

The DBA as a helpdesk.

By

Every one and again you will see people asking What skill do you think...

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

How to get feature key and feature value separated $ based on part id ?

By ahmed_elbarbary.2010

I work on sql server 2012 i need to get featurekey and feature value...

Setting Up SQL Server 2019 for Optimal Performance

By water490

Hi I have a very large database (600GB) that I am looking at creating. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers