By Kimberly L. Tripp, 01/24/2007
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. ...
By Kimberly L. Tripp, 01/24/2007
In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.
By Kimberly L. Tripp, 10/26/2006
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 ...
By Kimberly L. Tripp, 08/19/2003
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?
By Kimberly L. Tripp, 08/19/2003
Yes, you need to plan well for disaster recovery, but consider spending as much time on disaster prevention and minimization.
By Kimberly L. Tripp, 08/04/2003
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.
By Kimberly L. Tripp, 03/25/2003
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.
By Kimberly L. Tripp, 02/01/2003
Learn what you can and can't do with SQL Server views, and a few tips on better viewing habits.
By Kimberly L. Tripp, 12/01/2002
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.
By Kimberly L. Tripp, 11/26/2002
Here's a small homework assignment to help you create and access views.
By Kimberly L. Tripp, 10/01/2002
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 ...
By Kimberly L. Tripp, 10/01/2002
This homework assignment can help you further improve your ability to write scalar UDFs.
By Kimberly L. Tripp, 09/01/2002
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 ...
By Kimberly L. Tripp, 09/01/2002
For this homework assignment, try your hand at creating a UDF that returns datetime data in a specified format.
By Kimberly L. Tripp, 08/21/2002
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.
By Kimberly L. Tripp, 08/21/2002
Decisions about where to place data within filegroups can sink or save your restore, so plan carefully.
By Kimberly L. Tripp, 08/21/2002
Log backups are important to recovery, so why does SQL Server pause them during a full database backup?
By Kimberly L. Tripp, 08/21/2002
Using the file and filegroup backup strategy can help you quickly and easily recover from isolated failures.
By Kimberly L. Tripp, 08/21/2002
Frequent backups of msdb will ensure that you have the information you need to restore your database after a disaster.
By Kimberly L. Tripp, 07/01/2002
If you need to access and manipulate your datetime data, here are some tips and tricks that will make the job easier.