SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,177 reads
Blog Posts
The top 5 reasons to speak at SQL Rally
Have you been thinking about speaking at the upcoming SQL Rally in Dallas? If so, remember that the deadline for...
2012-01-20
741 reads
Unlimited Vacation
Unlimited Vacation sounds good, and maybe it works, but I wonder how much vacation people really take at Red Frog....
2012-01-20 (first published: 2012-01-12)
2,294 reads
Case Sensitive searches in T-SQL
I just ran into an issue with one of my applications where a SQL statement had updated a status code...
2012-01-19
2,776 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that those functions were in some DMOs and that you...
2012-01-19
4 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that...
2012-01-19
974 reads
How to let non-admin business users run replication agent jobs
This blog post is basic in nature but highlights a very real requirement that may arise when administering replication. Occasionally...
2012-01-19 (first published: 2012-01-13)
2,112 reads
Introducing “X on XMLA”
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
549 reads
Master Data Services 2012
As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...
2012-01-19
3,605 reads
Session Code – Extending Reporting Services with Custom Code
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...
2012-01-19
3,529 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers