I’m Speaking: PASS Summit 2012 and more…
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...
2012-07-12
737 reads
Performing Fast Searches of Query Plans
Performing Fast Searches of Query Plans
XML: Fast as a Turtle
I've made blog posts in the past on using the exist()...
2012-07-12
1,334 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,533 reads
Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,227 reads
Link List for July 12, 2012
Here are a few things I’ve found/had sent to me recently you may find interesting:
Most Common GRE Words. 400 words...
2012-07-12
686 reads
Denali – Memory: “any size” page allocations
I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...
2012-07-12
909 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,080 reads
SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,688 reads
SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,743 reads
SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...
2012-07-12
982 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