Focus on Your Passion
Tuesday night I was having a conversation with my younger son, whom we call Turtle. It's a nickname that came...
2010-03-04
1,094 reads
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example...
2010-03-04
574 reads
Timing Matters
A few weeks ago I got an email from my backup administrator with a message like this:
Set type : Backup
Set...
2010-03-04
316 reads
Self Promotion & Self Marketing
The title of this post illustrates my own ambiguity on the topic. It’s fair and necessary to let others know...
2010-03-04
639 reads
Heading to Charlotte
I think I’ll forever associate Charlotte, NC with my middle son. We were heading back to Denver from Virginia Beach...
2010-03-04
384 reads
Please Provide PASS with Feedback on its Speaker’s Resource Pages
The PASS Program Committee is gearing up for the 2010 PASS Community Summit “Call for Speakers”, and it would like...
2010-03-04
1,007 reads
How Not to Write a Resume Cover Letter
Although I am not currently a hiring manager, I occasionally receive unsolicited resumes from people looking for work. I just...
2010-03-03
1,508 reads
Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,749 reads
SQLSaturday #44!
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
348 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
350 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...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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