SQL Server 2022

Creating a Date Dimension (Calendar Table) in SQL Server

Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]

 dans Sites anglophones  étiqueté Analytics / business intelligence / data analysis / Date Calculations / date dimension / Date Formatting / Date Functions / Date Metadata / Date Range / Fiscal Year / Recursive CTE / Reporting / SQL programming / SQL Queries / SQL Server / SQL Server 2022 / SQL Server Development / SQL Tips / t-sql / time intelligence / Time Series Analysis par

Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions

Introduction SQL Server 2022 introduced the LEFT_SHIFT and RIGHT_SHIFT functions, which allow you to manipulate numbers by shifting […]

 dans Sites anglophones  étiqueté binary operations / bitwise operations / bitwise operations in SQL Server / bitwise shift / bitwise shift examples / data manipulation / date expressions in SQL / LEFT_SHIFT / RIGHT_SHIFT / Sql Functions / SQL optimization / SQL Server / SQL Server 2022 / t-sql par

Determining Whether Home Addresses Fall Within a Tornado Polygon Using ...

Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the […]

 dans Sites anglophones  étiqueté @SQLServer / Advanced SQL / Automating tornado alerts for policyholders using SQL Server / Azure SQL / Azure SQL Database / Claims triaging with SQL Server STIntersects() function / Convert latitude and longitude to SQL Server GEOGRAPHY / Efficient spatial indexing for large-scale risk modeling / Find homes at risk of tornado damage with SQL queries / Find properties in a tornado warning using SQL Server / geocode / Geospatial analytics for P&C insurance using SQL Server / GIS-based catastrophe modeling for property insurance / How insurers use SQL Server to track tornado damage / How to check if a location is inside a polygon in SQL Server / How to use SQL Server GIS functions for insurance analytics / Identifying tornado path exposure in SQL Server databases / Microsoft SQL Server / Microsoft SQL Server (MSSQL) / MS SQL / RDS SQL Server / Risk aggregation for tornado-prone properties using SQL Server / Spatial / Spatial Data / Spatial Data Types / SQL Server / SQL Server 2016 / SQL Server 2016 Performance / SQL Server 2017 / SQL Server 2017 on Linux / SQL Server 2019 / SQL Server 2022 / SQL Server Data Services / SQL Server polygon intersection for home location mapping / SQL Server spatial data for risk assessment in insurance / SQL Server spatial functions for tornado risk analysis / SQL Server spatial indexing for faster catastrophe modeling / SQL Server spatial queries for disaster preparedness / SQL Server spatial queries for insurance catastrophe modeling / SQL Server STIntersects() example for geographic data / SQLServerCentral / STGeomFromText SQL Server example for polygons / t-sql / T-SQL Challenges / Tornado exposure analysis for home insurance claims / Underwriting automation with SQL Server geospatial analysis / Using SQL Server geography data type for disaster risk mapping / Using SQL Server to assess tornado impact on insured homes par

Batch Execution Mode on a Rowstore in SQL Server 2022

Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]

 dans Sites anglophones  étiqueté #sql server interview questions / Azure SQL / azure sql server / Batch Execution Mode on Rowstore in SQL Server 2022 / Database Performance / Microsoft SQL Server / Microsoft SQL Server 2022 / performance enhancement / Performance Tuning / SQL Server / SQL Server 2019 / SQL Server 2022 par