when you use datetime parameters in SPs in the where clause the SP becomes very slow

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.05 (20)

2010-04-28 (first published: 2010-04-26)

2,838 reads

Blogs

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

I am thrilled to have been a part of this year’s Storage Field Day...

Forums

A client of ours is upgrading their database to SQL Server 2019. The edition...

Hi, I need to perform backup and save it in network drive. I have...

Hello Group, Do you have any available extended events to capture the queries run...