Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,800 reads
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,800 reads
Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query,...
2011-06-15
4,968 reads
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
740 reads
Yes, I went on the SQL Cruise to Alaska. Yes, it was as grand as you’ve heard. Yes, I’m going...
2011-06-08
536 reads
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,120 reads
Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...
2011-05-25
920 reads
SQL Azure is still SQL Server at the end of the day. This means it is entirely possible to write...
2011-05-23
1,392 reads
This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...
2011-05-18
735 reads
I’ve put in several abstracts for the 2011 Summit. This year we’re voting for preferred sessions. If you’re interested in...
2011-05-10
732 reads
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary...
2011-05-09
1,311 reads
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item 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