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

Scripts with tag Aggregates Rss

Search for any content tagged aggregates

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   

Script to get max dates on tables that contain a certain column.

This script will allow you to get maximum date associated with tables that contain a certain column.   Read more...
By Kishore T 2013/03/18 | Source: SQLServerCentral.com | Category: aggregates
Rating: |  Discuss |   Briefcase | 1,113 reads

Total Data Rows Data

This script will return the total amount of data rows in a database  Read more...
By Gordon Beeming 2011/08/19 | Source: SQLServerCentral.com | Category: summary
Rating: |  Discuss |   Briefcase | 984 reads

CLR Aggregate to Concatenate delimited strings

One must be carefull unless the input is sorted by the value passed to the function and there is no paralelism there is no guarantee that the resulting value will be sorted.  Read more...
By Gokhan Varol 2011/01/27 | Source: SQLServerCentral.com | Category: string
Rating: (not yet rated) |  Discuss |   Briefcase | 820 reads

SQL Function to get Max, Min values from given collection of values

This func returns the max value,min value and count of values from collection of values  Read more...
By Bharat Panthee 2011/01/20 | Source: SQLServerCentral.com | Category: aggregates
Rating: |  Discuss |   Briefcase | 1,725 reads

Function to generate sql statement returning max value

SQL script generator for max value 
By SoftJunk 2011/01/18 | Source: SQLServerCentral.com | Category: max
Rating: |  Discuss |   Briefcase | 1,459 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,406 reads
   Items 1 to 6 of 6