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.
SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
I am all set for my first MVP Global Summit 2009 in Seattle and Redmond, March 1 to 4, to meet other MVPs and the Microsoft product teams.
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.
SQLAuthority News – Ahmedabad User Group Meeting February 21 2009 – Meeting Report
My review of our Ahmedabad user group meeting February 21, 2009: a growing crowd, two sessions on index usage and IDENTITY, and great feedback.
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.