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

510 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

How to use Jupyter Notebook in VSCode

By Daniel Calbimonte

Comments posted to this topic are about the item How to use Jupyter Notebook...

The Last DBCC Date

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last DBCC Date

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers