Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,427 reads
Articles
SP_MSForeachtable - Life Without Cursors.
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,297 reads
Standing Back And Looking At Benchmark Results
What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.
2001-05-22
5,798 reads
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,370 reads
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,968 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,355 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,758 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,069 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,378 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,644 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers