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,971 reads
Noman072
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,170 reads
How to Download and Restore AdventureWorks 2019 Database
Learn how to download and restore AdventureWork 2019 Database.
2025-03-07
759 reads
Understanding the Logical Functions IIF and Choose in SQL Server 2022
Learn how to simplify conditional logic in SQL Server 2022 using the IIF and CHOOSE functions.
2025-03-05
3,008 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,069 reads
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022
Learn how to use bit manipulation functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022's. Learn practical examples and common errors to simplify binary data management.
2025-02-17
1,963 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,060 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,468 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,094 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,132 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
DeepSeek: What is new with this AI technology?
Comments posted to this topic are about the item DeepSeek: What is new with...
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers