SQL Server

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

Improving the Performance of UPDATE Statements in SQL Server

Introduction Performing bulk updates in SQL Server can be a resource-intensive operation, particularly when dealing with large datasets. […]

 dans Sites anglophones  étiqueté batch size / batch update / bulk update / CPU usage / database management / Database Performance / disk I/O / execution time / large datasets / locking contention / memory usage / performance analysis / performance metrics / query optimization / row-by-row update / SQL optimization / SQL Performance / SQL Server / SQL Server tuning / SQL Server update operations / SQL testing / system resources / t-sql 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

How to Download and Restore AdventureWorks 2019 Database

Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]

 dans Sites anglophones  étiqueté AdventureWorks / AdventureWorks 2019 / AdventureWorks database / Backup-Restore / database installation / database restore / install AdventureWorks / OLTP database / restore database / SQL Server / SQL Server backup / SQL Server guide / SQL Server Management Studio / SQL Server sample database / SQL Server tutorial / SSMS / 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

How to Download and Restore AdventureWorks 2022 Database

Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is […]

 dans Sites anglophones  étiqueté AdventureWorks / AdventureWorks 2022 / AdventureWorks database / Backup-Restore / database installation / database restore / install AdventureWorks / OLTP database / restore database / SQL Server / SQL Server backup / SQL Server guide / SQL Server Management Studio / SQL Server sample database / SQL Server tutorial / SSMS / t-sql par

Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE

Introduction Attaching databases in SQL Server can be a routine yet sometimes time-consuming task for Database Administrators (DBAs). […]

 dans Sites anglophones  étiqueté Administration / automate database attachment / Database Administration / database attachment / database management / DBAs / DBCC CHECKPRIMARYFILE / SQL Server / SQL Server commands / SQL Server Management Studio / SQL Server tips / t-sql par

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...

Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]

 dans Sites anglophones  étiqueté Administration / Cosine function / Degrees / Floating-point precision / Mathematical functions in SQL / Radians / Radians function / SQL best practices / SQL conversion errors / SQL function usage / SQL Server / SQL Server tips / SQL troubleshooting / t-sql / T-SQL tips / Trigonometric functions par

How to Attach and Detach Databases in SQL Server

Introduction Managing databases in SQL Server requires a solid understanding of various methods for transferring and maintaining data. […]

 dans Sites anglophones  étiqueté Administration / Attach Database / Backup and restore / data files / Database Administration / database management / Detach Database / log files / Mirroring / Replication / SQL Server / SQL Server Management Studio / SQL Server Security / SSMS / t-sql par

SQL Server Performances – CHAPITRE 3 – Estimateur de Cardinalité, ...

Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]

 dans Sites francophones  étiqueté drapeau de trace / Estimateur de Cardinalité / gourneur de ressources / Guides de plan / Indicateurs de jointure / Indicateurs de requête / indicateurs de table / Intelligent Query Processing / IQP / Magasin de requête / niveau d'isolation / optimiseur / Performances / Query Store / réglage au scope de la base / repère de plan / SQL Server / Uncategorized / verrouillage par

SQL Server Performances – CHAPITRE 2 – Faut-il paramétrer, régler, ...

Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]

 dans Sites francophones  étiqueté cache / CEIP / coeurs / comparaison / compatibilité / CPU / datetime / Instant File Initialization / large pages / Lock page in memory / mémoire / Mémoire compressée / multithread / NUMA / Optimisation / optimiste / parallelisme / Performance / Performances / pessimiste / RAM / requetes ad hoc / sp_configure / SQL Server / SQL Server CEIP / Statistiques / Tuning / verrou / verrouillage par