How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.
SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit
Does doubling the CPUs double the worker threads? No. Use sys.dm_os_sys_info to find Max Worker Count, and see the formula for 32 bit and 64 bit.
Keeping Up With SQL Server Without Drowning
Make keeping up SQL Server knowledge manageable with release-note reviews, one deep topic each quarter, and a small record of relevant changes.
A Daily DBA Checklist You Can Run as One Script
Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.
geometry STCrosses: Crossing Depends on the Intersection Dimension
geometry STCrosses uses the dimension and interior position of the intersection to define crossing. I compare it with endpoint contact and collinear overlap. A shared point or segment does not automatically satisfy that definition.
SQL SERVER – Difference Between GRANT and WITH GRANT OPTION
What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.
ISJSON Type Constraints: Validate the Top-Level Value
ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.







