What is the Object Explorer Details tab good for?
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
292 reads
How to Start Speaking
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
347 reads
2018-10-17
210 reads
Lookup. Foreign Key Constraint vs Check Constraint
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
469 reads
Extended Events Made Easy – Sorting, Grouping and Aggregation
When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace...
2018-10-29 (first published: 2018-10-16)
2,134 reads
Azure SQL Database Hyperscale
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions. SQL Database Hyperscale is...
2018-10-16
98 reads
Azure SQL Database Hyperscale
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st,...
2018-10-26 (first published: 2018-10-16)
2,431 reads
A Play Around With Table Variable Deferred Compilation in SQL 2019
Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...
2018-10-25 (first published: 2018-10-16)
2,092 reads
Conditionally Returning Rows Based On Query Results
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some...
2018-10-29 (first published: 2018-10-16)
2,683 reads
Conditionally Returning Rows Based On Query Results
Watch this week's video on YouTube
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can't get around adding some business formatting logic to...
2018-10-16
68 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers