How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,431 reads
Down and Dark
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,567 reads
X-XMLA: v. Creating XMLA Script from Visual Studio and Deploy the Database
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,179 reads
Want to lose #20PoundsBeforeTheSummit? Join the #GetHawt competition!
We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going...
2012-06-26
969 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
836 reads
Locking Behavior – Foreign Keys
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,757 reads
A Fire Drill and Voter Registration
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
796 reads
SQL Rally 2012 Nordic
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
888 reads
SQLBif Gets A Job - SQLCommunity Redeemed...
Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I...
2012-06-26
1,451 reads
Preach The Gospel Always, If Necessary Use Words
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
276 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