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

Articles with tag Performance testing Rss

Search for any content tagged performance testing

   Items 1 to 5 of 5   
 

What do you consider important when performance testing?

What data specific considerations do you make when preparing for performance testing?  Read more...
By Gary Varga 2014/08/07 | Source: SQLServerCentral.com | Category: performance testing
Rating: |  Discuss |   Briefcase | 199 reads

The Performance of Traversing a SQL Hierarchy

Dwain Camps shows that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can each be the fastest at some point. He illustrates the danger in generalizing from just one set of test data, and that it's foolish to assume that just because SQL code looks neat, it will perform well.  Read more...
By Additional Articles 2014/05/14 | Source: SimpleTalk | Category: performance testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,369 reads

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,960 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 | 138 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,170 reads
   Items 1 to 5 of 5