Technical Article

Performance problem in SQL Server 2005

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: […]

You rated this post out of 5. Change rating

2007-07-16

512 reads

Blogs

Monday Monitor Tips: VLF Alerts

By

A recent change made to Redgate Monitor to add a new alert for VLF...

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Read the latest Blogs

Forums

Keeping QUERIES for Using Again and Adding DB to Git/Github and VS Code

By Ahr Aitch

While I know that it will speed my learning to type queries as I...

Found a Tool Very Helpful for Beginner

By Ahr Aitch

I struggled with remembering the conventions I'd chosen when creating column names and data...

Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 )

By Johan Bijnens

How do you configure the cluster resources to be able to use Distributed Transactions...

Visit the forum

Question of the Day

Partial Backups I

What is a partial backup for a read-only database?

See possible answers