Executing scripts with sp_addscriptexec
Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec...
2012-02-10
2,676 reads
Speaking At SQL Saturday #110 in Tampa
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was...
2012-02-10
439 reads
Data Page math : 96 + 8060 + 36 = 8192. is this correct?
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,728 reads
An open letter to anyone with “SQL Server” on their resume
Dear Sir or Madam,
I have your resume here in my hand and couldn’t help but notice that you have listed...
2012-02-09
2,913 reads
RYO Maintenance Plan – Enhancement Request
In response to my last post, I got a very interesting comment from Philip:
“I would love to see a way...
2012-02-13 (first published: 2012-02-09)
1,563 reads
A Script A Day - Day 9 - Index Compression Estimations
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,320 reads
Stages of the Game?
Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...
2012-02-09
836 reads
SQL Server Product Life Cycle
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The...
2012-02-09
1,145 reads
SSAS: Currency Conversion in MDX Script
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
1,019 reads
February #Meme15 Assignment
It’s been a couple months now since a number of us got together to share how we use social networks...
2012-02-09
577 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