This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
zero

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 16, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.

Read More
Four places at a wooden table, with cake at two ribbon-marked cards and a hand lowering the second plate.

LEFT JOIN ON Clause: Conditions Decide Matches, Not Rows

March 15, 2009
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL NULL, SQL Scripts

Why a condition in ON keeps every customer, why a left-side condition removes nobody, and how one WHERE quietly undoes two LEFT JOINs.

Read More
An open brass cash drawer holds undisturbed coin stacks as a shop shutter is lowered.

End-of-Day Balances From a Transaction Table

March 11, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, Temp Table

A transaction table stores movements, not balances. Collapse each day, run a total, fill the quiet days and dodge the midnight trap.

Read More
SQL SERVER - Pad Ride Side of Number with 0 - Fixed Width Number Display

SQL SERVER – Pad Right Side of Number with 0 – Fixed Width Number Display

March 10, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

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.

Read More
SQL SERVER - 2008 - Find Relationship of Foreign Key and Primary Key using T-SQL - Find Tables With Foreign Key Constraint in Database

SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database

February 26, 2009
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

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.

Read More
Gouache painting: three long raised garden rows run away from the viewer, two planted with round cabbages and the third bare soil

XPath First Items: Parentheses Change the Selected Nodes

February 25, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

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.

Read More
Two matching glass pitchers contain water at different levels on a quiet kitchen counter.

When SSMS and Your Application Return Different Results

February 22, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Investigate SSMS different results by comparing connections, parameters, session options, transactions, and plans against the application.

Read More
Previous 1 … 287 288 289 290 291 292 293 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com