Failover consederations on Database Mirroring
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,215 reads
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,215 reads
Introduction
This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.
Database mirroring is a solution in SQL...
2012-03-05
1,811 reads
Introduction
The purpose of this tutorial is to lay out the general guidelines for planning a SQL Server 2005 upgrade. As...
2012-02-21
1,931 reads
Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL...
2012-02-03
799 reads
2012-02-03
537 reads
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