What is the difference between Union vs. Union All? UNION removes duplicates like SELECT DISTINCT, while UNION ALL returns every row. I compare both.
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.
SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip
Back home in Ahmedabad after the Microsoft MVP Summit trip: 10 days away, 5 packed business days, and links to all my daily posts and photos.
SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009
Many South Asian MVPs met at Global MVP Summit 2009. We toured Seattle, shared tips and decided to start guest blogging on each other’s blogs.
SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions
A summary of my two meetings near Toronto: the new Tech User Group of Markham led by Steve Jagadishan, and TorontoCASolutions. Lots of database talk.
SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database
On my flight to Toronto a reader asked how to insert image in database, so I wrote the T-SQL on my laptop right there. The script and sample image are here.
SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer
Day 4 of MVP Summit 2009 had four keynotes, and Steve Ballmer brought so much energy to his. I can not share details due to NDA, but here are my photos.