Using Nightly Populated Tables For Faster SQL Queries
A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality...
2011-06-05
1,300 reads
Blog Posts
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
581 reads
Maximum recursion possible with CTE in SQL Server 2005/2008
In my last blog about Tally Tables, we talked about the use of
recursive CTEs to generate Tally Tables. Following that,...
2011-06-04
20,297 reads
Analysis Services Operations Guide Released
The Analysis Services team has been working overtime lately to provide added community support for the traditional UDM-based OLAP engine...
2011-06-03
997 reads
Avoiding OR Conditions with Joins
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...
2011-06-03
2,835 reads
PerformancePoint 2010 source control
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
917 reads
Re-blog – May 27-June 2
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-03
499 reads
SQLSaturday #77 Pensacola Florida Event Preview
Sometimes, even if I’m not attending, some SQLSaturdays stand out to me, and catch my interest. I guess it’s a...
2011-06-03
1,010 reads
Use PowerShell to Add a Login to a Database Role in all Databases
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
6,195 reads
What is SSMS Addin
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
712 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