Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Choose a tag below, or browse popular content:
Administering
Database Design
Programming
SQL Server 7, 2000
Administration
Editorial
Reviews
Strategies
Advanced Querying
Miscellaneous
Security
T-SQL
Data Warehousing
Other
SQL Server 2005
Popular Articles
The Differences Between SQL Server 2000 and 2005
What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.
Read more...
By
Steve Jones
2007/08/31 (first posted: 2007/05/15)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
65,247 reads
SQL Server 2005 Build List
Build List Updated with Cumulative Update 7 for SP2.
Read more...
By
Steve Jones
2008/04/23 (first posted: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
43,836 reads
Passing a Table to A Stored Procedure
In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.
Read more...
By
Jacob Sebastian
2007/12/07 (first posted: 2007/05/30)
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
43,543 reads
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.
Read more...
By
Jeff Moden
2008/05/07
|
Source:
SQLServerCentral.com
|
Category:
TSQL
Rating:
|
Discuss
|
Briefcase
|
8,900 reads
Linking to the Previous Row
One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.
Read more...
By
David McKinney
2008/03/13
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
12,001 reads
Free Tools for the SQL Server DBA
Everyone has a set of handy utilities and tools that they use with their SQL Server, but sometimes convincing an employer to purchase tools is hard. Longtime DBA David Bird brings us a list of the tools he likes to use and are FREE.
Read more...
By
David Bird
2007/05/24
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
38,554 reads
TSQL LAB 2 - Writing Conditional WHERE Clauses
Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.
Read more...
By
Jacob Sebastian
2008/02/27
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
15,325 reads
Ten Ways To Lose Your DBA Job
We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.
Read more...
By
Steve Jones
2007/04/13 (first posted: 2006/11/30)
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
61,342 reads
Upgrading a Database SQL 2000 to SQL 2005
Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.
Read more...
By
Sachin Samuel
2007/05/16
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
30,317 reads
SQL Server 2005 Logins
Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005.
Read more...
By
Brian Kelley
2008/04/11 (first posted: 2006/07/05)
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005 - Security
Rating:
|
Discuss
|
Briefcase
|
81,347 reads
Hidden RBAR: Triangular Joins
Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.
Read more...
By
Jeff Moden
2007/12/06
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
11,881 reads
The Differences Between SQL Server 2000 and 2005 - Part 2
Steve Jones continues with his look at how SQL Server 2005 differs from SQL Server 2000, this time tackling the differences from a developer perspective.
Read more...
By
Steve Jones
2007/05/31
|
Source:
SQLServerCentral.com
|
Category:
News
Rating:
|
Discuss
|
Briefcase
|
25,105 reads
SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
Read more...
By
Kevin van der Merwe
2008/05/05
|
Source:
SQLServerCentral.com
|
Category:
Compression
Rating:
|
Discuss
|
Briefcase
|
7,389 reads
Row Level Versioning
Row Level Version is one of the most coolest features introduced by SQL 2005.
Read more...
By
Roy Ernest DBA
2008/04/07
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
9,523 reads
Becoming A DBA, Part 1
Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.
Read more...
By
BuckWoody
2007/12/20
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
10,447 reads
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
Read more...
By
Vincent Rainardi
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
MDX
Rating:
|
Discuss
|
Briefcase
|
13,341 reads
Sending scheduled SQL query results via HTML e-mail using SSIS
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
Read more...
By
Paul Clancy
2008/04/23
|
Source:
SQLServerCentral.com
|
Category:
SSIS
Rating:
|
Discuss
|
Briefcase
|
6,290 reads
The Cost of Function Use In A Where Clause
Discusses Index Selection impact when functions are wrapped around WHERE clause filtering columns
Read more...
By
Gregory Jackson
2008/02/28
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Optimization
Rating:
|
Discuss
|
Briefcase
|
9,876 reads
A Reporting System Architecture
This article describes one method of implementing a reporting system in SQL Server 2005
Read more...
By
Gregory Jackson
2008/01/21
|
Source:
SQLServerCentral.com
|
Category:
Reporting System
Rating:
|
Discuss
|
Briefcase
|
8,665 reads
NULL Versus NULL?
Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new tricks with NULLs.
Read more...
By
Michael Coles
2007/10/05 (first posted: 2007/02/26)
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
32,534 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use