This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
George Mastros (gmmastros)
About George Mastros (gmmastros)
George has been developing software professionally for 19 years, first for the department of defense, and then for various other companies. In 1998, George started his software company, Orbit Software, specializing in School Bus Transportation software. His specialty is refining SQL Server queries to deliver optimal performance.
Social Sitings
Summary
- Active from November 2008 to April 2012
- 45 posts published
Table of Contents
Posts
2012 (4 posts)
- Finding Exact Duplicate Indexes on April 12, 2012
- Do not use reserved keywords for your column names on March 19, 2012
- Friday SQL Nugget #1 on January 13, 2012
- SQLCop integration with Red Gate's SQL Test on January 4, 2012
2011 (3 posts)
- Zero-One-Some Testing on December 13, 2011
- tSQLt Unit Testing on July 20, 2011
- Understanding SQL Server 2000 Pivot with Aggregates on March 8, 2011
2010 (4 posts)
- T-SQL Tuesday #13: Is that what you really want? on December 14, 2010
- Picking a science fair project on November 3, 2010
- SQLCop update Version 1.1 on August 23, 2010
- SQL Server Proper Case Function on February 24, 2010
2009 (25 posts)
- Missing foreign key constraints on November 20, 2009
- Procedures with cursors on November 20, 2009
- Collation conflicts with temp tables and table variables. on November 19, 2009
- SQL Server collation conflicts on November 18, 2009
- Don't use text datatype for SQL 2005 and up on November 17, 2009
- Do not use the float data type on November 16, 2009
- Identify procedures that call SQL Server undocumented procedures on November 13, 2009
- Best Practice: Do not cluster on UniqueIdentifier when you use NewId on November 12, 2009
- Best Practice: Every table should have a primary key on November 11, 2009
- Do not use spaces or other invalid characters in your column names on November 10, 2009
- Always include precision and scale with decimal and numeric on November 9, 2009
- Always include size when using varchar, nvarchar, char and nchar on November 6, 2009
- Don't prefix your table names with tbl on November 5, 2009
- Don't start your procedures with SP_ on November 4, 2009
- Decimal and Numeric problems when you don't specify precision and scale on October 9, 2009
- SQL Server Extracting Data (again) on September 9, 2009
- IsNumeric, IsInt, IsNumber on July 15, 2009
- SQL Server Decode/Encode unicode data on July 8, 2009
- Automatically create a SQL Server table in a new database. on July 3, 2009
- VB6 Remove date part of DateTime on April 1, 2009
- SQL Server Zipcode Latitude/Longitude proximity distance search on February 11, 2009
- SQL Server covering indexes on February 4, 2009
- SQL Server Stored Procedure with nvarchar parameter on January 31, 2009
- SQL Server - Set based random numbers on January 24, 2009
- To-do list 2009 on January 3, 2009
2008 (9 posts)
- Calculating Mean, Median and Mode with SQL Server on December 22, 2008
- Extracting numbers with SQL Server on December 12, 2008
- SQL Server Rounding Methods on December 11, 2008
- SQL Quiz: Toughest Challenges on December 9, 2008
- SQL Server Case/When Data Type problems on December 4, 2008
- SQL Server Fibonacci Sequence on December 2, 2008
- SQL Server efficient handling of divide by zero on November 25, 2008
- SQL Server Precision And Scale Problems on November 24, 2008
- Setting a standard DateFormat for SQL Server on November 20, 2008