No more NebraSQL
After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?) I have...
2012-09-27
769 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,757 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,091 reads
SQL Server: Part 4 : Approaching Database Server Performance Issue
In the last three parts, we have discussed about different queries that can be used to list the current state...
2012-09-26
1,753 reads
DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
634 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
901 reads
WIT Wednesday
On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...
2012-09-26
1,139 reads
Participate in the PASS Election Process
Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...
2012-09-26
1,065 reads
One More Reason for Portable Applications
I bet most of us don’t think about installing software that we need/want to try. We’re either running as local...
2012-09-26
816 reads
Come See Us at SQL Saturday #165 in Lincoln!
I will be speaking with several of my House of Brick Technologies colleagues at SQL Saturday #165 in Lincoln in...
2012-09-26
591 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