A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)
I had a hardware issue this past weekend on one of my database servers where I am running SQL Server...
2010-01-18
1,544 reads
Blog Posts
Accidental DBA?
It seems to me that over the last year or so that there has been an explosion in the use...
2010-01-18
651 reads
Database Design Process
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked...
2010-01-18
1,917 reads
I'm Outta Here
Take care of the site, behave, and respect each other.
I'm off for a week in St. Martin, a belated honeymoon...
2010-01-18
732 reads
Intel Nehalem-EX and Database Performance
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
869 reads
Leaving on a Jet Plane
Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless. It will have been four...
2010-01-18
571 reads
Notes on the January 2010 oPASS Meeting (Live Meeting)
Before you dig in this post, take a look at my earlier notes about oPASS and Live Meeting and the...
2010-01-18
765 reads
Should You Achieve All Your Goals?
So many people wrote posts at the end of 2009 analyzing their goals and what they achieved. I did the...
2010-01-18
728 reads
Three Life-Changing Events
Paul Randal started a meme about three life changing events that brought him to where he is today. Brent Ozar...
2010-01-18
3,128 reads
What three events brought you here?
Another one of the DBA bloggers games of tag is occurring. I’ve been asked by Tom LaRock to answer Paul...
2010-01-18
752 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