Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,332 reads
Articles
Piping a Query to a Text File
The case where one has to send the results of a query to a text file comes up quite often. This quick tip will show you how to output the results of a query to a text file.
2001-05-21
11,932 reads
Prove Your Case and Win a Buck!
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
2001-05-21
3,324 reads
Quick Tip: Taking a Database Offline
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,709 reads
Tuning SQL Server Memory in 2 Minutes
You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.
2001-05-21
10,018 reads
VMWare
VMWare is a software product that is great for testing new ideas without having to purchase and install a separate machine.
2001-05-21
4,331 reads
SQL Server 2000 Black Book
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,600 reads
Using the Dynamic Properties Task
In SQL Server 7.0 Data Transformation Services (DTS), dynamically configuring packages was difficult. With the aid of a new Dynamic Properties task in SQL Server 2000, this assignment is easy.
2001-05-18
12,217 reads
More About the Fixed Database Roles
This article by Andy Warren provides an introduction to some of the fixed database roles and things to consider when using them.
2001-05-17
4,699 reads
Cell Phone Horror Stories
These are some stories that show the downside of everyone having cell phones.
2001-05-16
1,797 reads
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
What Foods Should You Eat to Reduce Erectile Dysfunction Symptoms?
Diet plays a crucial role in managing erectile dysfunction (ED) symptoms, and incorporating certain...
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