When Good Query Plans Go Bad
Today's story starts again with a page escalation:
--
We are seeing very high CPU usage on DistServer01. Could you please take...
2018-05-25 (first published: 2018-05-18)
3,158 reads
Blog Posts
Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,780 reads
Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,580 reads
Cosmos DB for the Data Professional
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,873 reads
Day 24 Replication Setup
Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed...
2018-05-24
298 reads
One Week to Music City Tech
Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in...
2018-05-24
728 reads
Power BI and Data Security – Audit Logs, Powershell, Power BI and @AngryAnalytics
The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...
2018-05-24
463 reads
Query Predicates
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
1,076 reads
Tips for Securing SQL Server Database from All Sort of Risks
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...
2018-05-24
25 reads
Tips for Securing SQL Server Database from All Sort of Risks
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...
2018-05-24
1,297 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