Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, pivot Rss

   Items 1 to 19 of 19   
 

PIVOT

By Steve Jones 2014/08/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,282 reads

PIVOT Me

By Steve Jacobs 2013/11/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,802 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,193 reads

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...  Read more...
By Kenneth Fisher 2013/04/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,505 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,451 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2012/12/06 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 8,869 reads

A Stock Price Correlation Matrix

Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function  Read more...
By John Ryle 2012/05/14 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 5,891 reads

Using PIVOT

how can use pivot for reporting  Read more...
By Pankaj Upadhyay 2010/08/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,389 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2010/06/02 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 3,174 reads

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 40,377 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2010/06/02 | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 3,174 reads

Dynamic table not imposible

I needed to display my data in columns but could not use pivots or cross tables because it wasn't a fix amount of columns. so I created this script, I hope is useful.  Read more...
By William Mendoza 2009/02/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,770 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,193 reads

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 40,377 reads

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.  Read more...
By Jesse Roberge 2008/10/24 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,056 reads

The Ultimate Duplicate Index Finder

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.  Read more...
By Jesse Roberge 2008/10/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,966 reads

The Ultimate Index Usage Reporter

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.  Read more...
By Jesse Roberge 2012/12/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 7,451 reads

The Ultimate Index Lister (Pivoted)

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.  Read more...
By Jesse Roberge 2008/10/09 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 2,406 reads

PIVOT working incorrectly?

One developer's journey through PIVOTing incorrectly.  Read more...
By Ryan Clare 2008/05/13 | Source: SQLServerCentral.com | Category: pivot
Rating: |  Discuss |   Briefcase | 7,508 reads
   Items 1 to 19 of 19   
 
Tags
crosstab (6)    
sql server 2005 (6)    
administration (5)    
indexing (5)    
maintenance (5)    
maintenance and management (5)    
performance tuning (5)    
utility (5)    
for xml path (4)    
list indexes (4)    
sys.dm_db_partition_stats (4)    
.net (1)    
blogs (1)    
correlation (1)    
cross apply (1)    
duplicate indexes (1)    
procedure (1)    
selectivity (1)    
sqlclr (1)    
sys.dm_db_index_usage_stats (1)    
tally table (1)    
tvp (1)