ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Hibernate ORM and SQL Server Interoperability When integrating Java applications using Hibernate ORM with Microsoft SQL Server, the framework relies on the configured Dialect to generate pagination T-SQL. For SQL Server 2012 and later, Hibernate typically utilizes the OFFSET-FETCH clause via setFirstResult and setMaxResults . However, older versions of SQL S
Comparing Online ADD NOT NULL with DEFAULT versus Full Table Rebuild When a small application requires a new column that cannot be null and must be initialized with a constant, two documented paths exist in SQL Server 2019 and later: an online ALTER TABLE that attempts to add the column without rebuilding the entire table, and a traditional rebuild that lock
Lock Escalation Behavior Microsoft SQL Server utilizes lock escalation to manage memory overhead by converting numerous fine-grained locks (row, key, or page) into a single table-level lock. While this reduces the resource cost of lock management, it can introduce significant latency in multi-session environments by transforming short-duration row waits into
TLS Handshake and Hostname Resolution When establishing a secure connection to Microsoft SQL Server using Encrypt=True and TrustServerCertificate=False , the client must validate that the server's identity matches the certificate provided during the TLS handshake. The validation process typically relies on the hostname specified in the connection string. If
Request Cancellation Behavior Microsoft SQL Server utilizes the Attention signal to notify the execution engine when a client-side command timeout expires or a user manually cancels a request. While this mechanism is designed to stop batch processing, the server must reach a safe checkpoint within the execution plan before the operation actually terminates.
Transactional DDL in SQL Server generally allows most CREATE, ALTER and DROP statements to be rolled back inside an explicit user transaction. Partition switching via ALTER TABLE ... SWITCH is a metadata operation intended to move data between partitions with minimal logging. The design question is whether the switch remains fully rollback safe when active t
Our SQL Server 2022 instances serve applications that connect using both fully qualified domain names (FQDNs) and short hostnames, depending on network zone and legacy configuration. We want to enforce encryption with certificate validation (Encrypt=true, TrustServerCertificate=false) in production, but the current self-signed certificate only contains the F
SQL Server's Read Committed Snapshot Isolation (RCSI) is designed to eliminate blocking between concurrent read and write operations by utilizing row versioning. This mechanism shifts the concurrency burden from the lock manager to the version store located in tempdb . In environments with high concurrency and frequent updates to large datasets, the overhead
Verification Strategy for Large Database Backups Ensuring the recoverability of a Microsoft SQL Server database requires balancing verification depth against available resources. Two documented methods provide different levels of assurance: RESTORE VERIFYONLY and a full RESTORE followed by DBCC CHECKDB . RESTORE VERIFYONLY confirms that the backup set is com
microsoftsqlserver