Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
5,113 reads
2015-10-22
1,842 reads
There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.
2015-04-16
9,580 reads
2014-05-09
2,207 reads
2013-06-04
2,403 reads
2013-05-30
2,142 reads
2009-03-18
5,235 reads
2008-07-03
10,694 reads
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Comments posted to this topic are about the item The Hash Join III
Comments posted to this topic are about the item Continuous Learning
Comments posted to this topic are about the item Virtualizing GCP data by using...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers