Another quick post of simple changes you can make to your code to create more optimal execution plans. This one is on implicit conversions. An implicit conversion is when...
2019-04-29 (first published: 2019-04-17)
1,153 reads
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc… However, not all environments allow you to use those features (eg. vendor...
2019-04-25 (first published: 2019-04-16)
1,257 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
13 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
15 reads
Got this email from a client in the southern US asking how to up their game in SQL Server, frustrated by a lack of hands-on opportunities to administer SQL...
2019-04-15
27 reads
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you...
2019-04-25 (first published: 2019-04-15)
699 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
30 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
151 reads
Greetings everybody! It has been a while since I posted anything here. I figured I...
2019-04-26 (first published: 2019-04-15)
769 reads
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...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Comments posted to this topic are about the item Learn From History
Comments posted to this topic are about the item The SQL Server MCP Server
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers