I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]
2007-07-16
512 reads
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I am able to successfully create managed identity on Azure SQLMI & Azure...
Comments posted to this topic are about the item Lower Your Attack Surface Area
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers