Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,702 reads
Kendal Van Dyke
Meme Monday
Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...
2011-04-04
399 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
401 reads
Has Microsoft Desktop Virtualization Reached The End Of The Road?
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
615 reads
STS-134 Rollout
If you follow me on Twitter or talk to me in person you'll come to realize I'm a space enthusiast....
2011-03-15
516 reads
MagicPASS March 2011 Meeting Notice
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
487 reads
I've Got A New Job
You've probably noticed I've been quiet on this blog lately, eeking out a post every other week on average. I've...
2011-02-24
1,524 reads
How Can I Help You Go To SQLRally?
I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...
2011-02-23
406 reads
MagicPASS February 2011 Meeting
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
538 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
718 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
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
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers