Cursors for T-SQL Beginners
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
22,348 reads
Wagner Crivelini
SQL and the JOIN Operator
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-02-25 (first published: 2009-10-07)
45,360 reads
Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.
2010-10-25
13,096 reads
2009-05-19
11,286 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