IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,404 reads
TSQL Tuesday #4: IO
“IO IO, It’s off to disk we go!” was in Mike Walsh’s blog post that introduced this TSQL Tuesday and...
2010-03-09
578 reads
T-SQL Tuesday – I/O Fallacies
It’s time for the March T-SQL Tuesday and this month Mike Walsh picked the topic. It’s I/O and you can...
2010-03-09
472 reads
An Introduction to Data Compression in SQL Server 2008
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.
There is one thing every...
2010-03-09
1,297 reads
Taking Advantage of SQL Server Tools
Reprinted from my editorial in Database Weekly.
An important question I think you should be asking yourself, when it comes to...
2010-03-09
355 reads
Easy Ways to Detect I/O Pressure in SQL Server 2008
It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems...
2010-03-09
4,593 reads
T-SQL Tuesday #004 Hosted by Mike Walsh
I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need...
2010-03-08
563 reads
SQL Server Locking & Block Scripts
A couple of weeks ago, I gave a presentation to the PASS DBA Virtual Chapter on SQL Server Locking & Blocking...
2010-03-08
564 reads
Notes from SQLSaturday #33
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
309 reads
MacGyver?
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...
2010-03-08
695 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