Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.
Steve has a few thoughts on natural keys, which often turn out not to be as unique as we expect.
Do you wonder why SQL Server ignores an index? Do you think about how you can deal with this problem? When you include too many columns in a query you decrease index selectivity. So, if you write a query like “Select * From …” the chance of choosing your nonclustered index will decrease.
There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]
Learn how to download and restore the AdventureWorks 2022 database in SQL Server with this step-by-step guide.
Today Steve asks which data model issues are most annoying to you.
In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.
Steve re-posts a question from someone else, asking why you wouldn't want to use an AI.
This next article in the Data Engineering with Fabric series showcases how tally tables can help load data in a Fabric warehouse.
By DataOnWheels
Hello data friends! Had a blast at my first ever M365 Community Day this...
By Steve Jones
One interesting concept in SQL Server is Deferred Name Resolution. This is something many...
By Kevin3NF
Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...
Comments posted to this topic are about the item List the Databases To Which...
We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30. Now we have 1 job...
Healing Zone Physiotherapy Clinic is a newly owned and well-established physiotherapy center located in...
What is returned from the following query ?
declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000' select dateadd(hour, 3.0/2, @currentDateTime);See possible answers