http://www.sqlmag.com/authors/author/author/5069886/rss/5069886en-USFri, 25 May 2012 10:42:18 GMTFri, 25 May 2012 10:42:18 GMThttp://www.sqlmag.com/article/performance/essential-aspects-of-database-design
By Kimberly L. Tripp
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. ]]>Kimberly L. TrippWed, 24 Jan 2007 00:00:00 GMThttp://www.sqlmag.com/article/performance/essential-aspects-of-database-designhttp://www.sqlmag.com/article/sql-server-2005/using-the-newsequentialid-guid-function
By Kimberly L. Tripp
In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.]]>Kimberly L. TrippWed, 24 Jan 2007 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2005/using-the-newsequentialid-guid-functionhttp://www.sqlmag.com/article/configuration/database-design-for-performance
By Kimberly L. Tripp
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.]]>Kimberly L. TrippThu, 26 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/configuration/database-design-for-performancehttp://www.sqlmag.com/article/backup-recovery/recovering-from-isolated-corruption
By Kimberly L. Tripp
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?]]>Kimberly L. TrippTue, 19 Aug 2003 00:00:00 GMThttp://www.sqlmag.com/article/backup-recovery/recovering-from-isolated-corruptionhttp://www.sqlmag.com/article/sql-server/an-ounce-of-prevention
By Kimberly L. Tripp
Yes, you need to plan well for disaster recovery, but consider spending as much time on disaster prevention and minimization.]]>Kimberly L. TrippTue, 19 Aug 2003 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/an-ounce-of-preventionhttp://www.sqlmag.com/article/high-availability/the-best-place-for-bulk_logged
By Kimberly L. Tripp
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.]]>Kimberly L. TrippMon, 04 Aug 2003 00:00:00 GMThttp://www.sqlmag.com/article/high-availability/the-best-place-for-bulk_loggedhttp://www.sqlmag.com/article/tsql3/detailed-aggregates
By Kimberly L. Tripp
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.]]>Kimberly L. TrippTue, 25 Mar 2003 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/detailed-aggregateshttp://www.sqlmag.com/article/tsql3/viewer-advisory
By Kimberly L. Tripp
Learn what you can and can’t do with SQL Server views, and a few tips on better viewing habits.]]>Kimberly L. TrippSat, 01 Feb 2003 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/viewer-advisoryhttp://www.sqlmag.com/article/tsql3/the-view-from-here
By Kimberly L. Tripp
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.]]>Kimberly L. TrippSun, 01 Dec 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/the-view-from-herehttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project-december-2002
By Kimberly L. Tripp
Here’s a small homework assignment to help you create and access views.]]>Kimberly L. TrippTue, 26 Nov 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project-december-2002http://www.sqlmag.com/article/tsql3/simplify-parameterize-reuse
By Kimberly L. Tripp
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.]]>Kimberly L. TrippTue, 01 Oct 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/simplify-parameterize-reusehttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project26549
By Kimberly L. Tripp
This homework assignment can help you further improve your ability to write scalar UDFs.]]>Kimberly L. TrippTue, 01 Oct 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project26549http://www.sqlmag.com/article/tsql3/datetime-for-durable-databases
By Kimberly L. Tripp
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.]]>Kimberly L. TrippSun, 01 Sep 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/datetime-for-durable-databaseshttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project-september-2002
By Kimberly L. Tripp
For this homework assignment, try your hand at creating a UDF that returns datetime data in a specified format.]]>Kimberly L. TrippSun, 01 Sep 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/t-sql-tutor-project-september-2002http://www.sqlmag.com/article/log-files/before-disaster-strikes
By Kimberly L. Tripp
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.]]>Kimberly L. TrippWed, 21 Aug 2002 00:00:00 GMThttp://www.sqlmag.com/article/log-files/before-disaster-strikeshttp://www.sqlmag.com/article/log-files/filegroup-usage-for-vldbs
By Kimberly L. Tripp
Decisions about where to place data within filegroups can sink or save your restore, so plan carefully.]]>Kimberly L. TrippWed, 21 Aug 2002 00:00:00 GMThttp://www.sqlmag.com/article/log-files/filegroup-usage-for-vldbshttp://www.sqlmag.com/article/log-files/log-backups-paused-for-good-reason
By Kimberly L. Tripp
Log backups are important to recovery, so why does SQL Server pause them during a full database backup?]]>Kimberly L. TrippWed, 21 Aug 2002 00:00:00 GMThttp://www.sqlmag.com/article/log-files/log-backups-paused-for-good-reasonhttp://www.sqlmag.com/article/tsql3/restoring-after-isolated-disk-failure
By Kimberly L. Tripp
Using the file and filegroup backup strategy can help you quickly and easily recover from isolated failures.]]>Kimberly L. TrippWed, 21 Aug 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/restoring-after-isolated-disk-failurehttp://www.sqlmag.com/article/tsql3/msdb-quick-tip
By Kimberly L. Tripp
Frequent backups of msdb will ensure that you have the information you need to restore your database after a disaster.]]>Kimberly L. TrippWed, 21 Aug 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/msdb-quick-tiphttp://www.sqlmag.com/article/tsql3/manipulate-and-calculate
By Kimberly L. Tripp
If you need to access and manipulate your datetime data, here are some tips and tricks that will make the job easier.]]>Kimberly L. TrippMon, 01 Jul 2002 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/manipulate-and-calculate