SQL Server 2000 Performance Tuning
A series of web presenatations from Microsoft about tuning SQL Server 2000.
Adding a Column using SQL_DMO
One of our readers needed some help with altering a table with DMO, so Andy has a code sample and some comments in general about how to add objects using DMO. It's good code and a very quick introduction to how objects work. Worth reading!
Speed of Partitioned Views
There has been some talk about the use of partitioned views in SQL Server 2000 to gain performance improvements for scale-out of applications. In this article by Neil Jacobson, he discusses his findings in respect of the speed of partitioned views.
When to Use Dynamic SQL
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
SQL Server Beta Programs!
SQL Server is releasing two Beta products this month, a 64-bit version of SQL Server 2000 and service pack 4 for SQL Server 7.0! Note: Liberty requires that customers have access to 64-bit machines. Participating in a SQL Server Beta program can be a lot of fun, with contests, promotions, newsgroup support with members of the SQL team at Microsoft, etc. Come sign up today!
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
Direct from Microsoft, learn how to achieve scalable, high-performance merge replication applications.
Support WebCast: How to Connect to Analysis Services over the Internet
See how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.
Reducing Round Trips - Part 2
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
The undocumented nature of sp_readerrorlog in SQL Server 2000
Sp_readerrorlog can read any file on the hard disk, not just error logs. Read on to learn how!
Blogs
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Dumping and Restoring Azure PostgreSQL Databases
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Forums
Enable a Disabled Index
Comments posted to this topic are about the item Enable a Disabled Index
Diving Deeper into the Import Extension in Azure Data Studio
Comments posted to this topic are about the item Diving Deeper into the Import...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers