The MERGE Statement – One Statement for INSERT, UPDATE and DELETE
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,309 reads
Blog Posts
T-SQL HOST_ID and HOST_NAME
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...
2015-04-20
3,529 reads
Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)
Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This post is dedicated to usage of...
2015-04-19
1,115 reads
How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
238 reads
How index gets dropped in Views in SQL Server
Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views...
2015-04-18
285 reads
Heraflux is Hiring
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development....
2015-04-17
456 reads
On Failure: On Being a Screw-Up
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,692 reads
On Software and OS Lifecycle Management
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-17
303 reads
Overview of the data visualization books by Stephen Few
I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual...
2015-04-17 (first published: 2015-04-07)
7,432 reads
Windows Phone – What Should Microsoft Do?
I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the...
2015-04-17
838 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers