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,825 reads
Blogs
What does the Machine Learning process look like?
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
Forums
DB Snapshot on TDE Enabled Database
Dear All, I have a DB on which TDE is enabled. When trying to...
Installing SQL 2017 Error
I am trying to install SQL Server 2017 Enterprise Edition. It is an Iso...
Select n records in table X from a field on table Y
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Ask SSC