Interesting Observation of ON Clause on LEFT JOIN
posted by pinaldave(9662) 3 years, 2 months ago 0
I am eager to know what SQL Experts and DotNet Experts think of this blog article. I did my best to write in as simple words as I can.
Reply
I would really like to get more feedback from users. So far I have not got much response on this, as it is quite important to know if this kind of articles user like or does not like.
Create UDF to Pad Ride Side of Number with 0 - Fixed Width Number Disp
I have written follow up post of this article as well : http://blog.sqlauthority.com/2009/03/16/sql-server-udf-pad-ride-side-of-number-with-0-fixed-width-number-display/ Regards, Pinal Dave
SQL SERVER - Find All Servers From Local Network - Using sqlcmd
Thanks for sending me email Ravi. I have posted corrected link.
Use T-SQL to script the Definition of all Stored Procedures in a DB
Nice work Suprotim. Really liked it.
SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
I am expecting that everybody will min of read this article to prevent any future error in their bug. Kick it! To save your hassle of other community fellow.
Introduction to JOINs - A simplest Visual Explanation of Join
posted by pinaldave(9662) 3 years, 1 month ago 0
Thanks for kicking it.
SQL Server 2005/2008 Diagnostics Queries and Configuration Checklist
posted by pinaldave(9662) 3 years ago 0
Great!
http://blog.sqlauthority.com/2009/06/17/sql-server-list-schema-name-an
posted by pinaldave(9662) 2 years, 11 months ago 0
The title was mistake. As I did not have edit facility I could not edit it. Hope you have liked the story. Kind Regards, Pinal
Moving data between two ListBoxes - Difference between jQuery 1.3.2 an
posted by pinaldave(9662) 2 years, 3 months ago 0
very very good!
Stored Procedure Optimization Tips – Best Practices
Thanks for wonderful comments on blog.
I strongly encourage all of you who visit original link to read the comments and enrich the article with additional input. Kind Regards, Pinal
Rollback TRUNCATE Command in Transaction
posted by pinaldave(9662) 2 years, 2 months ago 0
Thank you guys for your excellent participation on this subject.
SQL SERVER – Interview Questions & Answers Needs Your Help
Thanks you for your wonderful suggestions so far on blog.
virtual database - A Unique Tool for Testers, DBA, Developers
posted by pinaldave(9662) 2 years, 1 month ago 0
Thank you all that you liked this too. Yes, it is indeed important tool for all developers and not limited to SQL or Database only.
SQL SERVER – GUID vs INT – Your Opinion
posted by pinaldave(9662) 2 years ago 0
Thank you for wonderful participation and all this actions.