Slow SP with date parameters solved.
when you use datetime parameters in SPs in the where clause the SP becomes very slow
2010-04-28 (first published: 2010-04-26)
2,827 reads
Blogs
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Forums
Help needed in checking dates spans and status
Hello All, I have a requirement where we need to merge spans if the...
List of all OWNERS, not db_owner
How can I get a list of all database owners in an instance (not...
Document recovery procedure
Trying to document a process in an event of disaster and different reasons. In...
Ask SSC