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

Content with tag Performance testing Rss

   Items 1 to 9 of 9   
 

Getting Started with Columnstored Index in SQL Server 2014 – Part 2

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests.  Read more...
By Additional Articles 2013/11/06 | Source: Database Journal | Category: columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 3,878 reads

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2013/10/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,608 reads

Comparing Stored Procedures, Part 3

Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2011/03/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,171 reads

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2013/10/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,608 reads

Method to the Madness

Instead of piling on more, often increasingly complex, tools, Tony believes what is needed is a clear roadmap and methodology for systematically addressing SQL Server Performance issues.  Read more...
By Tony Davis 2009/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

Performance Testing SQL 2008’s Transparent Data Encryption

The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?  Read more...
By Additional Articles 2009/04/28 | Source: Database Journal | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,125 reads

Comparing Stored Procedures, Part 5

Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2009/04/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,102 reads

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2013/10/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,608 reads

Comparing Stored Procedures, Part 3

Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2011/03/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,171 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (3)    
string comparison (2)    
text matching (2)    
columnstore index (1)    
editorial (1)    
query optimization (1)    
sql server 2008 (1)    
transparent data encryption (tde) (1)