chapman.tim-gmail, Author at TechRepublic

chapman.tim-gmail

Tim Chapman is a SQL Server MVP, a database architect, and an administrator who works as an independent consultant in Raleigh, NC, and has more than nine years of IT experience.

CXO
Comparing cursor vs. WHILE loop performance in SQL Server 2008

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

chapman.tim-gmail
Published: November 10, 2009, 11:03 PM PST Modified: November 10, 2009, 11:03 PM PST Read More See more CXO articles
Cloud
Help! My SQL Server Log File is too big!!!

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems.

chapman.tim-gmail
Published: September 22, 2008, 6:26 AM PDT Modified: September 22, 2008, 6:26 AM PDT Read More See more Cloud articles
Tech & Work
How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

chapman.tim-gmail
Published: August 6, 2008, 3:06 AM PDT Modified: August 6, 2008, 3:06 AM PDT Read More See more Tech & Work articles
Developer
Sorting character strings using SQL Server

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

chapman.tim-gmail
Published: March 3, 2008, 3:22 AM PST Modified: March 3, 2008, 3:22 AM PST Read More See more Developer articles
Data Management
Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need to worry about constructing and parsing XML data. Learn about other benefits of the feature, as well as its minor drawbacks.

chapman.tim-gmail
Published: August 27, 2007, 5:47 AM PDT Modified: August 27, 2007, 5:47 AM PDT Read More See more Data Management articles
Data Management
Defining cascading referential integrity constraints in SQL Server

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

chapman.tim-gmail
Published: June 25, 2007, 4:27 PM PDT Modified: June 25, 2007, 4:27 PM PDT Read More See more Data Management articles
Data Management
See performance gains by using indexed views in SQL Server

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if indexed views will be beneficial to your database.

chapman.tim-gmail
Published: February 16, 2007, 11:07 AM PST Modified: June 8, 2007, 10:09 AM PDT Read More See more Data Management articles
Data Management
Explore how SQL Server’s system databases work

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

chapman.tim-gmail
Published: August 14, 2006, 5:32 AM PDT Modified: June 8, 2007, 10:05 AM PDT Read More See more Data Management articles

chapman.tim-gmail

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Help! My SQL Server Log File is too big!!!

How do I assign permissions to users to see SQL Agent Jobs?

Sorting character strings using SQL Server

Passing table valued parameters in SQL Server 2008

Defining cascading referential integrity constraints in SQL Server

See performance gains by using indexed views in SQL Server

Explore how SQL Server’s system databases work

Power Checklist: Building Your Disaster Recovery Plan

Hiring Kit: Project Manager

SSL Certificate Best Practices Policy

Mobile Device Computing Policy