SQL Server 7.0 Log Shipping Frequently Asked Questions
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
Find The First Row
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
Microsoft Certification Exams Included in VA Education
Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).
Using Stored Procedures from ADO 2.1
If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.
Multiple paths in DTS Workflow
This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.
Missing Temp Tables - Follow Up
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
Undocumented T-SQL Tricks With Logs
An interesting feature added to SQL Server 7.0 and 2000 is the ability to purge
an error log through a stored procedure or DBCC command. In this article, Brian Knight shows some of the undocumented stored procedures to detect, read and purge an SQL Server error log in T-SQL.
Optimizing SQL Server Performance Using Files and Filegroups
Learn how to boost the performance of SQL Server by making proper use of filegroups.
Blogs
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
Forums
[Telegram:.+1331642-0693] dollari falsi online
Titolo: Banconote false: svelare la minaccia della moneta contraffatta Introduzione::☎️(Telegram……[ +1(331)642–0693]£CA$$€¥ £ La circolazione...
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
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