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.
2018-02-09 (first published: 2016-07-12)
11,044 reads
2016-06-03
1,749 reads
2016-05-17
1,411 reads
2016-05-13
1,872 reads
2016-05-10
1,448 reads
2016-04-29
1,354 reads
2016-04-19
1,647 reads
2016-04-18
1,777 reads
2016-04-07
1,731 reads
2016-04-06
1,786 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers