Kimberly L. Tripp
|
|
Kimberly L. Tripp works as a speaker, writer, trainer, and consultant for her own company, SYSolutions, Inc. She writes for SQL Server Magazine, is a technical contributor for the SQL Server 2000 Resource Kit, and is coauthor of SQL Server 2000 High Availability (Microsoft Press). She is a SQL Server MVP and a Microsoft Regional Director.
Email address: kimberly@sqlskills.com
Web site: http://www.sqlskills.com
|
37 results found for Kimberly L. Tripp, displaying items 1 - 20
|
 |
Essential Aspects of Database Design
What's important to consider in designing a database? For optimal performance, you need to be mindful about three interrelated factors: indexing, maintenance, and statistics. Here's some advice to get you started in the planning process.
SQL Server Magazine
Using the newsequentialid() GUID Function
In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.
SQL Server Magazine
Database Design for Performance
In a database performance-engineering process, applying the right design techniques will ensure smooth-running operations. Here’s a laundry list of essential technical items you need to include in your process.
SQL Server Magazine
Recovering from Isolated Corruption
When disaster strikes only a subset of data, take the easiest route to recovery. Why undertake a full database restoration if faster recovery options are available?
SQL Server Magazine
An Ounce of Prevention
Yes, you need to plan well for disaster recovery, but consider spending as much time on disaster prevention and minimization.
SQL Server Magazine
|
August 4, 2003 |
|
The Best Place for Bulk_Logged
If your environment can’t afford data loss, your safest bet is to use the Full database recovery model as your primary recovery model and control changes through Bulk_Logged.
SQL Server Magazine
|
March 25, 2003 |
|
Detailed Aggregates
When you want more than just the summary data that GROUP BY can give, using COMPUTE and COMPUTE BY is the best way to get the details and aggregates.
SQL Server Magazine
|
February 1, 2003 |
|
Viewer Advisory
Learn what you can and can't do with SQL Server views, and a few tips on better viewing habits.
SQL Server Magazine
|
December 1, 2002 |
|
The View from Here
Part one in a series of articles that explain everything you need to know about using views and achieving the best query performance with them.
SQL Server Magazine
|
November 26, 2002 |
|
T-SQL Tutor Project, December 2002
Here's a small homework assignment to help you create and access views.
SQL Server Magazine
|
October 1, 2002 |
|
T-SQL Tutor Project
This homework assignment can help you further improve your ability to write scalar UDFs.
SQL Server Magazine
|
October 1, 2002 |
|
Simplify, Parameterize, Reuse
Until the advent of SQL Server 2000, if you wanted to encapsulate a simple expression, you had to hard-code it in a view. Now you can use a UDF to encapsulate the expression and reuse it. Flexibility is the key.
SQL Server Magazine
|
September 1, 2002 |
|
Datetime for Durable Databases
Developers can use the tools in SQL Server 7.0 and earlier releases to script datetime data for storage in existing databases, but the scalar UDF introduced in SQL Server 2000 is more flexible, efficient, and user friendly.
SQL Server Magazine
|
September 1, 2002 |
|
T-SQL Tutor Project, September 2002
For this homework assignment, try your hand at creating a UDF that returns datetime data in a specified format.
SQL Server Magazine
|
August 21, 2002 |
|
Log Backups Paused for Good Reason
Log backups are important to recovery, so why does SQL Server pause them during a full database backup?
SQL Server Magazine
Restoring After Isolated Disk Failure
Using the file and filegroup backup strategy can help you quickly and easily recover from isolated failures.
SQL Server Magazine
Msdb Quick Tip
Frequent backups of msdb will ensure that you have the information you need to restore your database after a disaster.
SQL Server Magazine
Before Disaster Strikes
Don't wait until a disaster hits your company. Make a solid backup plan and test it now to make sure that your data will survive a crash.
SQL Server Magazine
Filegroup Usage for VLDBs
Decisions about where to place data within filegroups can sink or save your restore, so plan carefully.
SQL Server Magazine
|
July 1, 2002 |
|
Manipulate and Calculate
If you need to access and manipulate your datetime data, here are some tips and tricks that will make the job easier.
SQL Server Magazine
|
|
Register
