August 2003
You can't execute a stored procedure from a CASE expression, but you can use CASE to return a character string that you can use in the execution of the stored procedure.
August 2003
Learn how to delete multiple records from a table by using a view as the filter.
June 2003
Microsoft provides answers about the capabilities of SQL Server 2000's full-text search component.
June 2003
Use SQL Server Profiler to determine which indexes you need to keep on your tables.
June 2003
SQL-DMO gives you a way to list jobs running on SQL Server and obtain their scripts.
May 2003
Microsoft's SQL Server development team takes a close look at a query that works from the inside out to return information from tables that are related only indirectly.
May 2003
How can I keep SQL Server 7.0 from truncating varchar data?
May 2003
When you delete rows, pages, or extents, SQL Server can mark those objects as "ghosts" and clean them up later. Here's how one DBA unearthed these ghostly objects while investigating a mysterious error code.
April 2003
SQL Server doesn't rename directories as part of the upgrade process. Here's a renaming problem you might face when upgrading and how to handle it.
April 2003
Here's a replication tip for ensuring the data that your franchises transfer to your head office is synchronized and includes modifications from each branch.
April 2003
Do you need to defragment your database but still maintain high availability? Microsoft offers several options for defragmenting tables in SQL Server 2000.
March 2003
Microsoft's SQL Server development team explains how to import Word documents into SQL Server, then index them.
March 2003
A sample script shows how to remove extraneous spaces from a char column.
February 2003
Manually checking and defragmenting your database's tables can be a laborious process. Here's how you can eliminate fragmentation from the start and how to automate defragmentation when you need it.
February 2003
How can you add a column to a replicated table without reinitializing the entire publication? The SQL Server Development Team has an answer.
February 2003
Here's how to use the ROWCOUNT setting to divide a long update into batches and maintain good performance.
January 2003
Wrapping your stored procedure call with state-change logic will let you determine the execution status of the procedure.
January 2003
Generate scripts to recreate stored procedures and triggers every time you set up replication.
January 2003
Microsoft's SQL Server development team shares 3 approaches for importing an XML file into SQL Server 2000.
December 2002
What constitutes a covered query? What’s the definition of a covering index? And when do you use one, or the other, or both? Microsoft’s SQL Server development team sheds light on one reader’s question.
Add these Headlines to your Website
