A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,816 reads
John Ryle
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
2011-10-18
8,130 reads
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
Replace Primary Server keeping same Log Shipping Server
I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...
Memory Issue With A SQL Server Express 2019 Server Database Application
Hi, I have just moved a DB from an old HP laptop, to a...
Use Zonal RIs for less than 100% utilization?
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
Ask SSC