Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,253 reads
The Numbers Don’t Lie… Except When They Do
There are few things more reassuring for a data professional than having clean, consistent data to back up critical business...
2009-12-08
632 reads
December Patches
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
505 reads
T-SQL Tuesday #001 – Dates and Times
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
469 reads
Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,171 reads
Fundamentals of Storage Systems – RAID and Hard Disk Reliability, Under the Covers
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,528 reads
ASK SQLServerCentral
We've had the ASK SQLServerCentral site up for a couple months now and while I see traffic continuing over there,...
2009-12-08
600 reads
Travel Recap for 2009
Starting Wednesday, December 9, 2009, I am on vacation until Monday, January 4th, 2010. Instead of traveling somewhere else for...
2009-12-08
409 reads
Microsoft Certified Master: SQL Server 2008 Pre-reading List
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are...
2009-12-08
1,085 reads
LinkedIn Update and LinkedIn Vanity URL’s
Was just doing my more or less weekly update on LinkedIn and saw that – finally – just hit 500 connections. Growth...
2009-12-07
571 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