A DMV a Day – Day 8
We have two related DMVs for Day 8. The first one is sys.dm_fts_active_catalogs, which is described by BOL as:
Returns information...
2010-04-08
1,259 reads
Blog Posts
A Good Expansion on the Topic of Plagiarism
In a previous post I gave some links which help explain what plagiarism is and how to generally avoid it....
2010-04-08
669 reads
Data-Driven Subscriptions at OPASS
Six months ago, I spoke at a SQLSaturday in Orlando, Florida. I had a great time. Andy Warren (Blog | Twitter),...
2010-04-08
338 reads
Early Planning for SQLSaturday Orlando 2010
I did an hour or so call with Jack Corbett recently to review what we hope to accomplish this year....
2010-04-08
297 reads
Q1 - review
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
676 reads
Spring Training 2010
Life was busier than I would have liked this year, but made it to one game, Braves vs Tigers, for...
2010-04-08
281 reads
SQL University Starting Back Up
Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...
2010-04-08
744 reads
What Do I Need to Do After Moving a Database to SQL 2005/2008?
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
400 reads
2010 Goals – First Quarter Review
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
481 reads
A DMV a Day – Day 7
I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...
2010-04-07
1,231 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers