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

Content with tags Performance Tuning, Database Design Rss

   Items 1 to 12 of 12   
 

An nHibernate Head Scratcher

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.  Read more...
By David Poole 2011/04/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,027 reads

Improving Database Design and Performance Using Compression

This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.  Read more...
By Suresh Maganti 2010/11/18 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 8,444 reads

Time Bomb Design - A Longer Fuse

In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.  Read more...
By David Poole 2010/05/26 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 10,318 reads

Time Bomb Coding

Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.  Read more...
By David Poole 2010/02/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,341 reads

Finding a better candidate for your clustered indexes

When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.   Read more...
By Additional Articles 2008/12/26 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 3,449 reads

Name Value Pair - Part II

In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.  Read more...
By Teshome Asfaw 2008/05/19 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 7,337 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,884 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,884 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,872 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,796 reads

Relational Database Without Relations

The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.   Read more...
By Eugene Bereznuk 2002/07/29 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,659 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,233 reads
   Items 1 to 12 of 12   
 
Tags
sql server 7 (4)    
basics (3)    
t-sql (3)    
administration (1)    
ado (1)    
data types (1)    
indexing (1)    
miscellaneous (1)    
name value pair (1)    
naming standards (1)    
nhibernate (1)    
partition (1)    
programming (1)    
row compression (1)    
sql server 6.5 (1)    
strategies (1)    
visual basic 6 (1)    
xml (1)