THREAT

Technical Article

RE: Stored Proc vs Query

  • Reply

I removed the parameter from the SP and executed the SP (declare local variable and assign value instead) and it ran fine. I got the results in about 7 minutes. I tested this change in one server and I am testing it in other servers now. I will let you know. Thanks. 

You rated this post out of 5. Change rating

2005-03-08

Blogs

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers