Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
Best Practices
Refine your search with one of the following additional tags (with number of items):
Best and Worst Practices
(12)
Miscellaneous
(2)
Data Compression
(1)
SQL Server 2005
(1)
SQL Server 7, 2000
(6)
Naming Standards
(2)
Database Mirroring
(1)
SQL Server 2008
(1)
T-SQL
(5)
Security
(2)
delimited data
(1)
SQLServerCentral
(1)
Strategies
(4)
Administration
(1)
DTS
(1)
System Development Life Cycle
(1)
Data Warehousing
(2)
Capacity planning
(1)
Installation
(1)
Table aliases
(1)
Database Design
(2)
Coding Standards
(1)
Performance Tuning
(1)
Writing readable code
(1)
Integration Services (SSIS)
(2)
CSV Data
(1)
Items 1 to 20 of 32
Next 20 >>
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
|
6,021 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...
By
Additional Articles
2009/11/03
|
Source:
MSSQLTips.com
|
Category:
Integration Services (SSIS)
Rating:
Rate this
|
Briefcase
|
3,447 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
|
2,922 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
|
1,510 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
|
7,785 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
|
7,505 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
2009/06/22
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
21,331 reads
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
Read more...
By
Sylvia Moestl Vasilik
2009/05/07
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
7,590 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 reads
Tutorial: SSIS best practices
Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server.
Read more...
By
Additional Articles
2008/12/17
|
Source:
SearchSQLServer
|
Category:
Integration Services (SSIS)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
6,061 reads
Best Practices for Data Warehousing with SQL Server 2008
There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.
Read more...
By
Additional Articles
2008/09/12
|
Source:
TechNet
|
Category:
Best Practices
Rating:
Rate this
|
Briefcase
|
3,841 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 reads
Best Practices when performing maintenance in a DBM environment
If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:
Read more...
By
Additional Articles
2008/03/27
|
Source:
SQL Community
|
Category:
Database Mirroring
Rating:
Rate this
|
Briefcase
|
1,573 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 reads
More RBAR and "Tuning" UPDATEs
SQL Server expert Jeff Moden discusses a common problem seen in many update statements.
Read more...
By
Jeff Moden
2008/03/14
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
9,373 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 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
2009/02/09 (first published: 2007/11/27)
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
27,989 reads
Items 1 to 20 of 32
Next 20 >>
Most popular
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
2009/06/22
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
21,331 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
|
6,021 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
|
2,922 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use