Tabs Out of Control
I was working with a team of developers this week who were having the hardest time finding the keystroke to...
2009-11-03
331 reads
Table and Index Partitioning Demo
I get a lot of requests for explanations about the different concepts and the easiest way to demo partitioning in...
2009-11-03
358 reads
Smooth Compound Operators
Ok, so I can’t promise you’ll be smooth by the end of this entry, but I can promise you’ll be...
2009-11-03
244 reads
Kick xp_sendmail to the curb
With the advent of SQL Server 2005 and 2008, mail in the database engine has changed dramatically. Previously you had...
2009-11-03
1,434 reads
Week of Warehousing - Questions Answered
Greg emailed me a great question from my week of warehousing webinar the other day. We were discussing disk performance...
2009-11-03
271 reads
Check out Straight to 8 Program
We seem to be busting at the seams lately with quality content from great providers. I wanted to recommend to...
2009-11-03
226 reads
Week of Warehousing Review
How exciting was last week! Some of the top experts in the country all gathered together through support from SQLServerCentral.com,...
2009-11-03
205 reads
The Enduring DBA
We are all facing the challenges of this new economy. There are very few people and industries in the world...
2009-11-03
303 reads
PASS Summit 2009 - Ted Kummert
After Bob Muglia, Ted Kummert came on stage. He's the senior VP of the server tools division and works for...
2009-11-03
944 reads
Reference to PASS Session - T-LOG
Hey, just caught wind of some timely stuff going on at PASS. Had my trusty 'Google alert' email me, set...
2009-11-03
819 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers