Bit shifts fill vacant positions with zero and discard bits past the type width. Compare tinyint with int and a negative shift direction.
SQL SERVER – Function Property – Deterministic or Non-Deterministic
How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.
XQuery distinct-values: Deduplicate Atomic Values, Not Nodes
XQuery distinct-values removes repeated atomic values rather than selecting representative source nodes. I rebuild a small sorted XML result from repeated text. The example also keeps an empty document in view.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
NOT and NULL: Unknown Does Not Become True
NOT and NULL do not create a complete two-way classification. State whether missing values belong in a filter or a separate reporting category.







