Planning a Longer Break Soon
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
494 reads
Better Than a Business Card?
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
592 reads
Troubleshooting SQL Server Database Mirroring Problems with Best Practices: Requirements, and the 64-bit Benefit
As mentioned in previous disaster recovery posts and article, during my current mandate I have been tasked with what will...
2009-11-11
12,093 reads
Looking Back – PASS Summit 2009 Day 3
I started Wednesday planning on going to the Quest sponsored breakfast (plus presentation about DMVs) but when I bailed when...
2009-11-11
708 reads
IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,912 reads
Speaking at the .NET User Group meeting
When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory...
2009-11-11
292 reads
Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,618 reads
Baton Rouge SQL Server User Group
If you are in the Baton Rouge Area stop by and join our user group meeting this evening. The details...
2009-11-11
561 reads
PASS Summit 2009 – Fun
I’m not a big party guy, and in fact, more than a few people can attest to the fact that...
2009-11-11
822 reads
SQL Server MVP Deep Dives Book Signing at PASS
The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the...
2009-11-10
391 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...
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