February 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. Here's some advice to get you started in the planning process.
SQL Server Magazine
February 2007
In SQL Server 2005, you can use a new GUID function called newsequentialid() to populate your uniqueidentifer column.
SQL Server Magazine
November 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 need to include in your process.
SQL Server Magazine
September 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?
SQL Server Magazine
September 2003
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
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
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
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
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
Here's a small homework assignment to help you create and access views.
SQL Server Magazine
October 1, 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 reuse it. Flexibility is the key.
SQL Server Magazine
October 1, 2002
This homework assignment can help you further improve your ability to write scalar UDFs.
SQL Server Magazine
September 1, 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 more flexible, efficient, and user friendly.
SQL Server Magazine
September 1, 2002
For this homework assignment, try your hand at creating a UDF that returns datetime data in a specified format.
SQL Server Magazine
September 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.
SQL Server Magazine
September 2002
Decisions about where to place data within filegroups can sink or save your restore, so plan carefully.
SQL Server Magazine
August 21, 2002
Log backups are important to recovery, so why does SQL Server pause them during a full database backup?
SQL Server Magazine
September 2002
Using the file and filegroup backup strategy can help you quickly and easily recover from isolated failures.
SQL Server Magazine
September 2002
Frequent backups of msdb will ensure that you have the information you need to restore your database after a disaster.
SQL Server Magazine
July 1, 2002
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
Add these Headlines to your Website
