Basics QA on Extended Event
Basics QA on Extended Event
I am learning Extended Event so this is my first blog on extended event, There is...
2011-12-23
1,810 reads
SQL Server Sample Databases – All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-23
1,466 reads
Tis The Season to be Giving...#SQLFamily
Indeed the Holiday Season is traditionally a season of giving, and being charitable to those who are less fortunate. Although giving...
2011-12-23
1,699 reads
Data Driven Subscription failed with timeout error
One fine day, one of our data driven subscription which was running fine, failed with timeout error.
library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling...
2011-12-23
1,218 reads
2011 What A Great Year
What A Diffrince A Year Makes
In January I posted up my new years list basically, stuff I wanted to learn in...
2011-12-22
1,038 reads
How many calls – A T-SQL Question
I got a call from a friend recently that was looking for some query help. He was actually using Access,...
2011-12-22
1,311 reads
The #Meme15 Round-Up
The first round of #meme15 has finished. In total, there were eighteen people that participated. If there were more, I...
2011-12-22
850 reads
A SQL Server Christmas Card
Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint
SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho
WHILE @tiers...
2011-12-22
817 reads
PASS Summit 2011 Eval Results
My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63....
2011-12-22
651 reads
SQL Server Sample Databases - All Versions
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...
2011-12-22
1,273 reads
Blogs
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...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
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