Notes from the field - SP1 Personal Edition
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
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.
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers