Executing Multiple Scripts in a Folder using the ScriptRunner Utility
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
Security Alerts and Information
A new security alert affecting SQL Server was released on June 12, 2001
Implementing Data Quality Through Meta Data
Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
Service Pack 1 for SQL Server 2000 Released
In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.
Clonation and the Case of Table Dolly, Part 1
In software, clonation can sometimes turn out to be an extremely helpful technique. More often than not, in fact, you catch yourself duplicating instances of running objects to produce nearly identical objects to be managed codewise in a fairly independent way.
Using Index Intersections
First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.
Using SET to Tune Your Queries
On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. This article looks at how the STATISTICS IO and STATISTICS TIME options can help us tune queries.
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
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
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers