Daily Coping 8 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-08
18 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-08
18 reads
Quick Tip Remove CONVERT/CAST from your WHERE clauses and JOINS when comparing to variables of different data types. Set their data types to match your table definitions before using...
2022-04-08 (first published: 2022-03-28)
779 reads
Registration for the Data Community Summit opens today! You can sign up and come to Seattle in November with all the other data platform pros that you’ve missed seeing...
2022-04-08 (first published: 2022-03-31)
91 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-07
18 reads
Foreword
I was always wondering what the KEEP PLAN hint does. The documentation isn’t very specific (emphasis mine):
Forces the Query Optimizer to relax the estimated recompile threshold for a query.
In...
2022-04-07
58 reads
SQL Saturday is coming back to Jacksonville this May. I’m excited to go as I’ve like the city, but I’ve never been to this particular SQL Saturday. On May...
2022-04-07
14 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-06
13 reads
I have been doing some testing with Redgate’s Flyway Desktop as a new way of managing code for databases. However, just like Git, I appreciate clients, but I want...
2022-04-06 (first published: 2022-03-21)
339 reads
For this week, here is a short post about reinventing the wheel. An interesting conversation happened on Twitter where Dave Dustin asked: “Does anybody have an example of using...
2022-04-06
26 reads
In this new video series, Devin focuses on working with Power Automate Date Expressions. This first video is a primer to cover the basics of
2022-04-06 (first published: 2022-03-23)
397 reads
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
It's been donkeys years since this has happened to me, but I cannot remember...
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Which of these inputs is the smaller input to a hash join?
See possible answers