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,333 reads
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,333 reads
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
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
An interesting database option which is hidden from Enterprise Manager in SQL Server 7.0 is offline.
2001-05-21
9,711 reads
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,021 reads
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
A review of the SQL Server 2000 Black Book from the Coriolis Black Book series.
2001-05-18
4,601 reads
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,220 reads
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
These are some stories that show the downside of everyone having cell phones.
2001-05-16
1,797 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
I have a numeric column called "Value" in a flat file, which contains both...
I have a numeric column called "Value" in a flat file, which contains both...
Comments posted to this topic are about the item Are We Dinosaurs?
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers