Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.
SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
A guest post from Michael Coles, author of Pro SQL Server 2008 XML: a practical XML demo that looks at the query plan cache and the cost of cached operations.
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
LEFT JOIN ON Clause: Conditions Decide Matches, Not Rows
Why a condition in ON keeps every customer, why a left-side condition removes nobody, and how one WHERE quietly undoes two LEFT JOINs.
End-of-Day Balances From a Transaction Table
A transaction table stores movements, not balances. Collapse each day, run a total, fill the quiet days and dodge the midnight trap.
SQL SERVER – Pad Right Side of Number with 0 – Fixed Width Number Display
A reader needed a fixed width number display, like 1 shown as 0000001. SQL Server has no ready-made function, but a simple string trick does it.
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.