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

Content with tag Best Practices Rss

   Items 1 to 20 of 40    Older >>
 

Getting the Most out of Statistics

Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!  Read more...
By Edward Pollack 2014/06/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 5,062 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 115,685 reads

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.   Read more...
By Additional Articles 2013/11/28 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 6,113 reads

Disk Is Cheap! ORLY?

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,379 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 115,685 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 115,685 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 115,685 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,286 reads

9 Things to Do When You Inherit a Database

Some tips on what to do when you inherit a database that you've never worked on before   Read more...
By Sylvia Moestl Vasilik 2012/06/15 (first published: 2009/06/22) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 53,766 reads

Where Do You Go for Authoritative SQL Server Best Practices?

There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.   Read more...
By Brad McGehee 2011/06/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 412 reads

Disk Is Cheap! ORLY?

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,379 reads

9 Things to Do When You Inherit a Database

Some tips on what to do when you inherit a database that you've never worked on before   Read more...
By Sylvia Moestl Vasilik 2012/06/15 (first published: 2009/06/22) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 53,766 reads

SQL Server Integration Services (SSIS) - Design Best Practices

In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1, Part 2 and Part 3) of this series I briefly talked about SSIS and few of the best practices to consider while designing SSIS packages. Continuing on this path I am going to discuss some more best practices of SSIS package design, how you can use lookup transformations and what considerations you need to take, the impact of implicit type cast in SSIS, changes in SSIS 2008 internal system tables and stored procedures and finally some general guidelines.  Read more...
By Steve Jones 2009/12/14 | Source: MSSQLTips.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 4,956 reads

T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses

Query performance can be affected by many different factors. This article introduces another best practice of how and how not to use a function within your T-SQL statements.  Read more...
By Additional Articles 2009/11/04 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,194 reads

SQL Server Integration Services (SSIS) Performance Best Practices

This tip is going to cover recommendations related to the SQL Server Destination Adapter, asynchronous transformations, DefaultBufferMaxSize and DefaultBufferMaxRows, BufferTempStoragePath and BLOBTempStoragePath as well as the DelayValidation property.  Read more...
Rating:  Rate this |   Briefcase | 5,275 reads

Building Code that Promotes Plan Re-usage

This article, the third in the T-SQL Best Practices series, discusses how to write your code to promote cached plan re-usage. Understanding how white space and comments impact whether a plan is cached or an existing plan is re-used can help you minimize the number of plans your application is caching.  Read more...
By Additional Articles 2009/08/31 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 3,431 reads

Data Compression: Strategy, Capacity Planning and Best Practices

The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.  Read more...
By Additional Articles 2009/08/11 | Source: Microsoft MSDN | Category: data compression
Rating:  Rate this |   Briefcase | 2,190 reads

T-SQL Best Practices – Part 2

Continuing our discussion covering T-SQL best practices, this article focuses on how to optimize writing a jack-of- all-trades stored procedure (SP).  Read more...
By Additional Articles 2009/08/10 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,672 reads

T-SQL Best Practices

This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.  Read more...
By Additional Articles 2009/07/24 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 8,485 reads

9 Things to Do When You Inherit a Database

Some tips on what to do when you inherit a database that you've never worked on before   Read more...
By Sylvia Moestl Vasilik 2012/06/15 (first published: 2009/06/22) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 53,766 reads
   Items 1 to 20 of 40    Older >>
 
Tags
best and worst practices (12)    
sql server 7 (6)    
t-sql (6)    
strategies (4)    
database design (3)    
integration services (ssis) (3)    
administration (2)    
data warehousing (2)    
miscellaneous (2)    
naming standards (2)    
security (2)    
capacity planning (1)    
coding standards (1)    
csv data (1)    
data compression (1)    
database mirroring (1)    
database weekly (1)    
data-modeling (1)    
datatypes (1)    
dba (1)    
delimited data (1)    
dts (1)    
editorial (1)    
execution plan (1)    
installation (1)    
nightly jobs (1)    
performance (1)    
performance tuning (1)    
query optimizer (1)    
scalar function (1)    
sql server 2000 (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server agent (1)    
sqlservercentral (1)    
statistics (1)    
system development life cycle (1)    
system tables (1)    
table aliases (1)    
writing readable code (1)