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)
777 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
57 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)
395 reads
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Hi All I am a complete novice so I apologise for any incorrect terminology....
Hi everyone I have two tables storing stock prices. Each table comes from a...
hi i need "sample size" in my report's 4th data region which is a...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers