SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,177 reads
PASS Summit Evals – Plan Cache Querying
This past year, I spoke at the PASS Summit for the second time. The first time was a couple years...
2012-01-04
777 reads
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
997 reads
Have You Planned Which SQL Server Events You Will be Attending in 2012?
2012 is already upon us and I have been busy working on my travel schedule for this year. It is...
2012-01-04
678 reads
January Question: What feature(s) of SQL Server would you like to learn more about?
Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with...
2012-01-04
689 reads
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,579 reads
Difference between ETL and ELT
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,598 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
10 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a...
2012-01-04
905 reads
Presenting at OPASS on January 10, 2012
I’m stepping out of blogging-break mode for a few minutes to share that I’ll be presenting Building Your Professional Development...
2012-01-04
693 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers