Pictures in a database are easy to insert and easy to regret. Here is where the bytes go and how to choose a storage method.
SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database
A T-SQL script that finds every table with a foreign key constraint and shows how each foreign key relates to its primary key, now with schema names.
XPath First Items: Parentheses Change the Selected Nodes
XPath first items can mean one per parent or one overall. Compare step-local [1] with a parenthesized path, including full XML and empty selections.
SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
A reader asked how to disable Windows Authentication in SQL Server. The short answer: it can not be disabled, and it is the most secure way to log in.
When SSMS and Your Application Return Different Results
Investigate SSMS different results by comparing connections, parameters, session options, transactions, and plans against the application.
Value Histograms: Counting Rows per Range Bucket in T-SQL
Turn a column of amounts into a clear shape. Three small traps decide whether your bucket counts are true: empty buckets, uneven ranges and BETWEEN.
Checking IDENTITY Columns Before They Run Out of Numbers
Check IDENTITY columns for their current value, type limit and remaining range, including descending increments, before inserts fail.