Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,972 reads
January #Meme15 Assignment
Last month, a number of us got together to share how we use social networks to enhance our careers and...
2012-01-09
570 reads
Morning Checks - Forewarned is forearmed
It’s always handy to know if there any problems with your servers before you get into work in the morning....
2012-01-09
668 reads
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at...
2012-01-09
6 reads
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or...
2012-01-09
563 reads
Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
This is a revised post of an original article that I first published in December. Even though I thought that...
2012-01-09
259,927 reads
SQL Server –WRITELOG and how to reduce it
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common...
2012-01-09
1,274 reads
Meme Monday - All in the #SQLFamily
Yes, it's Monday again, and not only that - it's another edition of Meme Monday (the first of 2012), started by...
2012-01-09
1,358 reads
What I Will Do For You in 2012
Many of you have first hand experience of our phenomenal sql community (affectionately labelled the #sqlfamily).
Your first encounter with it...
2012-01-09
602 reads
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we...
2012-01-07
9,432 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