Professional SQL Server 2000 DTS Review
Steve Jones reviews the premier DTS reference for SQL Server 2000.
Steve Jones reviews the premier DTS reference for SQL Server 2000.
This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping AS SELECT cl.CityNameID, cl.CityName, o.OrderID, o.Customer, o.OrderDate, o.CustomerID, o.cityId FROM dbo.CityList AS cl INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID GO CREATE OR ALTER FUNCTION GetShipCityForOrder ( @OrderID INT ) RETURNS VARCHAR(50) WITH SCHEMABINDING AS BEGIN DECLARE @city VARCHAR(50); SELECT @city = os.CityName FROM dbo.OrderShipping AS os WHERE os.OrderID = @OrderID; RETURN @city; END; goWhat is the result? See possible answers