How SET DATEFIRST changes the first day of the week, and how @@DATEFIRST returns the current value, which also changes with SET LANGUAGE. Simple examples.
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error 1418 says the server network address cannot be reached or does not exist. Check the firewall, then enable TCP/IP for the server and client on port 1433.
SQL Server Interview Questions and Answers Complete List Download
The SQL Server Interview Questions and Answers Complete List Download collects my six part series in one PDF, as many readers asked.
SQL Server Interview Questions and Answers Part 6
Interview Questions and Answers Part 6 covers the six properties of relational tables and de-normalization, adding redundant data to help performance.
SQL Server Interview Questions, Part 5: Practical Answers
Practical SQL Server interview questions cover administration, settings, replication, string functions and data integrity. Compare small examples of string replacement and row counting, and keep each answer within its intended scope.
SQL Server Interview Questions and Answers Part 4
Interview Questions and Answers Part 4 begins with SQL Profiler: what it is, how it captures events to a file or table, and how to keep traces small.
SQL Server Interview Questions and Answers Part 3
Interview Questions and Answers Part 3 opens with NOLOCK: how the hint skips read locks, why that means dirty reads, and what it does for concurrency.
SQL Server Interview Questions and Answers Part 2
Interview Questions and Answers Part 2 explains clustered vs non-clustered indexes and the index configurations a table can have. The updated set has moved.
SQL Server Interview Questions and Answers Part 1
Interview Questions and Answers Part 1 starts with the basics: what an RDBMS is and what normalization means. The updated set now lives at a new location.
geometry STContains: Check Boundary Membership
geometry STContains differs from STIntersects at a polygon boundary. Four literal points expose the intended inclusion rule without treating ordinary language as a spatial predicate.