Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Missing Date Ranges- the Sequel
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Many Uses of Coalesce in SQL Server
Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.
Congratulations to Our New MVPs
Two longtime members of the SQLServerCentral.com community received the well-deserved MVP status this week. Congratulate Jeff Moden and Michael Coles.
Recursive Queries using Common Table Expressions (CTE) in SQL Server
The problem arises when the hierarchy level increases as SQL Server is limited to 32 levels of recursion. We need a better way to implement recursive queries in SQL Server 2005. How do we do it?
Slowly Changing Dimension in SQL Server 2005 – Part 2
This article is Part 2 in the series which explores the options available in SQL Server 2005 for Slowly Changing Dimensions
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Langkah praktis cara menonaktifkan - menutup kartu kredit UOB
Untuk menutup kartu kredit Bank UOB, Anda dapat mengh??bungi UOBCall melalui Whats?????? (62 0882-201^14008):...
BCA KCP Samarinda Seberang TLP/WhatsApp 08216977749
Jl. Bung Tomo, RT.001/RW.01, Baqa, Kec. Samarinda Seberang, Kota Samarinda, Kalimantan Timur 75132
BCA KCP Pangkalan Bun TLP/WA 08216977749
Jl. Ahmad Yani, RT.015/RW.04, Baru, Kec. Arut Sel., Kabupaten Kotawaringin Barat, Kalimantan Tengah 74112
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