Shrink Database Log Files One by One
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
4,632 reads
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
4,632 reads
Read when you search for help on the internet. You might miss a very important part of what you must do.
2013-06-10
4,886 reads
2010-09-30
2,929 reads
2010-09-06
4,045 reads
I had a request from a client who prints a lot of cheques each month and there control over the cheques went a bit haywire. The requested me to create some controls in their system to make sure that the cheques are use in cheque number sequence.
2009-01-20
1,125 reads
This article talks about the sharing of knowledge in forums such as SQLServerCentral.
2008-11-25
3,327 reads
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,390 reads
By Steve Jones
This value is something that I still hear today: our best work is done...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
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...
At work we've been getting better at writing what's known as GitHub Actions (workflows,...
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