SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag count() Rss

   Items 1 to 20 of 31    Older >>
 

There is a New COUNT in Town

Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this article, Greg Larson tests the new APPROX_COUNT_DISTINCT function for performance and accuracy.  Read more...
By Additional Articles 2018/12/13 | Source: SimpleTalk | Category: sql server 2019
Rating: (not yet rated)  Rate this |   Briefcase | 4,705 reads

Basic COUNTs 4

By Steve Jones 2018/02/09 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,027 reads

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.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,208 reads

Basic COUNTs 3

By Steve Jones 2018/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,082 reads

Basic COUNTs 2

By Steve Jones 2018/01/26 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,082 reads

Basic COUNTs 1

By Steve Jones 2018/01/19 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,142 reads

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 431 reads

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/07/12 (first published: 2015/01/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,081 reads

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.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,208 reads

SQL query

By Mohammad Tanweer Khan 2016/03/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,766 reads

Count Function Result (2)

By G. C. 2016/01/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,769 reads

Count Function Result (1)

By G. C. 2016/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,749 reads

The Lonely Count

By Steve Jones 2016/01/07 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,672 reads

The TOP 10 Count

By Eirikur Eiriksson 2015/10/22 | Category: top
Rating: (not yet rated) |  Discuss |   Briefcase | 1,820 reads

Counting Rows

By Shiva N 2015/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,038 reads

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,340 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2015/01/30 (first published: 2013/10/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,274 reads

Getting Distinct

By Steve Jones 2015/01/23 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,600 reads

Distinct Counts

By Steve Jones 2015/01/22 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,403 reads

COUNT NULLs

By Steve Jones 2015/01/21 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,550 reads
   Items 1 to 20 of 31    Older >>
 
Tags
t-sql (23)    
aggregates (11)    
null (3)    
dax (2)    
calculation (1)    
card (1)    
coalesce() (1)    
column (1)    
counta() (1)    
countax() (1)    
countx() (1)    
delimited (1)    
distinct (1)    
filter (1)    
formula (1)    
function (1)    
group by (1)    
isnull (1)    
matrix (1)    
measure (1)    
power bi (1)    
power bi desktop (1)    
powerpivot (1)    
report (1)    
slicer (1)    
sql server 2019 (1)    
stairway series (1)    
string (1)    
string manipulation (1)    
string occurences (1)    
sum (1)    
sum() (1)    
top (1)    
top 100 (1)    
visualization (1)    
window functions (1)