SQL Server

How to Safely Remove a SQL Server Data File Without ...

Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios.  Managing […]

 dans Sites anglophones  étiqueté Administration / Administrator / Data File Cleanup / Database Administration / DBCC / DBCC Shrinkfile / Real-World DBA Tips / SQL Server / SQL Server Disk Management / SQL Server File Management / SQL Server; Performance / Zero Downtime Maintenance par

Understanding MERGE to Insert, Update, and Delete Data Simultaneously

Introduction In modern database management, data synchronization plays a critical role in processes like data warehousing and ETL […]

 dans Sites anglophones  étiqueté Advanced SQL / batch processing / Data Management / data modification / data synchronization / database indexing / database management / database operations / database synchronization / Error Handling / ETL / INSERT UPDATE DELETE / MERGE / MERGE statement / performance optimization / SQL / SQL best practices / SQL Queries / SQL Server / SQL Server tips / SQL Server; Performance / SQL tutorial / t-sql par

Understanding CROSS APPLY and OUTER APPLY in SQL Server

Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]

 dans Sites anglophones  étiqueté cross apply / INNER JOIN / left join / OUTER APPLY / SQL Basics / SQL Function / SQL Join / SQL optimization / SQL Performance / SQL programming / SQL Queries / SQL Query Examples / SQL Server / SQL Subquery / SQL tutorial / t-sql / Table-Valued Functions / TVF par

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