Sql samples, sql tips
Sql server 2000 2005 2008 2008R2, 2012 samples, tips, books, sharing.
Showing posts with label
Performance issue while Pivoting huge records and creating a view
.
Show all posts
Showing posts with label
Performance issue while Pivoting huge records and creating a view
.
Show all posts
Thursday, May 16, 2013
[SQL Server Data Warehousing] Performance issue while Pivoting huge records and creating a view
›
There's no doubt that pivoting that amount of data will use a lot of resources - however the question is not whether you should perform ...
Tuesday, May 14, 2013
[SQL Server Data Warehousing] Performance issue while Pivoting huge records and creating a view
›
I have a table1 with more than 300 columns and 90 million records. I have 40 pivoted columns in this table. I would like to remove the ...
›
Home
View web version