SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,018 reads
Who wants to be a millionaire? - SQLQuiz
I have a question for all you DBA’s and SQL Professionals out there. It’s an exciting new contest that is...
2010-09-27
1,351 reads
SQL Server Quiz 2010
SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will...
2010-09-27
1,120 reads
Project Phoenix For Unemployed and Underemployed Developers
SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over...
2010-09-27
677 reads
Journal: SQL Saturday #52
Friday
6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.
9:30am local time, we...
2010-09-27
697 reads
Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,452 reads
Parameter Name Size And Performance
I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...
2010-09-27
1,043 reads
Orlando – Reminder to Register for SQLSaturday #49
We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards...
2010-09-27
640 reads
Index Black Ops Part 4 – Index Overhead and Maintenance
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-09-27
1,144 reads
SQLRally After Hours
One of the things we’re trying to do at SQLRally (May 2011 in Orlando!) is support and grow the social...
2010-09-27
576 reads
Blogs
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...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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