Auditing changes in Merge Replication
One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...
2012-10-17 (first published: 2012-10-10)
2,905 reads
Blog Posts
Indexing Book Winner
Back on October 3, I put up a post about a free indexing book. And specifically about Expert Performance Indexing for...
2012-10-17
572 reads
Inserted and Deleted are One Table?
Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...
2012-10-17
2,439 reads
Lost in Translation – Deprecated System Tables – sysfulltextcatalogs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-17
634 reads
PASS 2012 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,750 reads
PASS Election Results Posted
Congratulations to Wendy Pastrick, James Rowland-Jones, and Sri Sridharan on winning a two year term on the PASS Board of...
2012-10-17
805 reads
Querying database usage
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,510 reads
SQL In The City: Seattle
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,147 reads
SQL Server Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-17
956 reads
Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
3,000 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers