Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.
2003-04-14
3,214 reads
This article expands Steve Jones' look at ways to audit changes by examing how you can deal with the large amounts of data generated.
2003-04-07
10,568 reads
Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.
2003-03-31
5,370 reads
What should SQL Server Central provide to the community in a review? Read on and give us some feedback so we can make this site better.
2003-03-24
3,503 reads
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,935 reads
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,815 reads
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,136 reads
Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.
2003-02-17
4,612 reads
In SQL Server 2000, there is a database option to close the database when it is not in use. Every wonder what this is? Or when it should be used? Steve Jones takes a look at this seldom used option.
2003-02-10
12,007 reads
I've had to call Microsoft quite a few times for support this year. Was it worth it? Read on to see when you should decide to call.
2003-02-06
6,159 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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