2015-10-13
1,594 reads
T-SQL
2015-10-09
1,857 reads
2015-10-05
1,815 reads
2015-10-02
1,251 reads
How to Avoid Conditional JOINs in T-SQL
Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.
2015-10-02
7,474 reads
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
19,275 reads
2015-09-24
1,723 reads
2015-09-23
1,677 reads
2015-09-22
1,573 reads
T-SQL Window Functions Speed Phreakery
Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.
2015-09-18
4,213 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
Forums
BCA KCP Kramat Jaya Call CSO; (+62 821°3111°179
Call CSO; (+62 821°3111°179 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec....
BCA KCU SALATIGA WHATSAPP 08388331786
WhatsApp 08388331786.Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers