Coffee and SQL

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...

2013-07-10

830 reads

Unlocking “Lock Pages in Memory” Option

Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...

2013-07-08

346 reads

It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...

2013-07-07

329 reads

Probably the best piece of advice I ever received is to take time to...

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

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?