Improving the Performance of UPDATE Statements in SQL Server
Learn how to optimize UPDATE performance in SQL Server by examining three different methods of making large updates.
2025-03-26
4,446 reads
SQL Server
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Learn how to use the LEFT_SHIFT and RIGHT_SHIFT bitwise functions in SQL Server 2022.
2025-03-19
4,093 reads
How to Download and Restore AdventureWorks 2019 Database
Learn how to download and restore AdventureWork 2019 Database.
2025-03-07
745 reads
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
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.
2025-03-04 (first published: 2025-03-03)
2,439 reads
How to Download and Restore AdventureWorks 2022 Database
Learn how to download and restore the AdventureWorks 2022 database in SQL Server with this step-by-step guide.
2025-02-28
1,035 reads
Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT
Learn how to effectively use SQL Server's data type conversion functions PARSE, TRY_PARSE, and TRY_CONVERT
2025-02-07
2,051 reads
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Learn how to quickly and efficiently attach multiple SQL Server databases using the undocumented DBCC CHECKPRIMARYFILE command. Automate the process with minimal effort, saving time and reducing errors.
2025-01-27
1,463 reads
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
2025-01-13
3,089 reads
Resolving Access Denied Errors During SQL Server Database Attachment
Learn how to resolve access denied errors when attaching databases in SQL Server. This guide explores file permission settings, focusing on the differences between Windows and SQL logins, and provides a step-by-step solution to prevent common attachment issues.
2025-01-10
1,129 reads
How to Attach and Detach Databases in SQL Server
Learn how to effectively attach and detach databases in SQL Server, exploring the differences between these methods and traditional backup and restore procedures. Streamline your database management tasks with clear, step-by-step instructions.
2024-12-30
1,647 reads
Blogs
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Forums
Transactional Replication from Read replica
If I have Read replica (in Azure SQL MI), can it be used as...
SQL availability group and file server role answering from the same name
Hello, I'm tasked with setting up a 2 node server cluster that will host...
Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices
Comments posted to this topic are about the item Microsoft Power BI Performance Best...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers