LessThanDot Site Logo


A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Discuss Share Learn

Top Forum Users

The top ranked users for the past 30 days:
  • No users rated in the last 30 days

Blog Statistics

Most viewed blog posts

RankViewsPosttitleNumber of CommentsBlogger
13394051Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released0SQLDenis
22003189Upgrade Assistant for SQL Server 2012 available for download0SQLDenis
31681228SQL Server Code Name “Denali” CTP3 Product Guide available for download0SQLDenis
4358516Scripting all jobs on SQL Server 2005/2008 into one file7SQLDenis
5332724Always include precision and scale with decimal and numeric8George Mastros (gmmastros)
6290778Do not use spaces or other invalid characters in your column names14George Mastros (gmmastros)
7276082Watch all the Tech·Ed North America 2011 SQL Server videos5SQLDenis
8224157Calculating Mean, Median and Mode with SQL Server27George Mastros (gmmastros)
9179258Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters14SQLDenis
10158587Missing foreign key constraints8George Mastros (gmmastros)
11155536SQL Server Zipcode Latitude/Longitude proximity distance search85George Mastros (gmmastros)
12152742Stupid me #3 – Building the script component0Koen Verbeeck
13146394SQL Server Filegroup Piecemeal Restores6Jes Borland
14134161Always include size when using varchar, nvarchar, char and nchar4George Mastros (gmmastros)
15132243How to get information about all databases without a loop30Naomi Nosonovsky
16130596The Ten Most Asked SQL Server Questions And Their Answers56SQLDenis
17127658Tips and Tricks to Make SQL Server Management Studio Awesome44Jes Borland
18125972Free ASP.NET MVC eBook Tutorial in pdf format5SQLDenis
191214026 ways to import data into SQL Server19Ted Krueger (onpnt)
20113888SQL Server Types - Numeric vs Int14Eli Weinstock-Herman (tarwn)
21113419SQL Server DBA Tip 15 – SQL Server Agent – Job ownership1Ted Krueger (onpnt)
22106165How I prepared myself for the MCSE certification36Koen Verbeeck
23106100T-SQL Tuesday 32: A Day in the Life a Grrl Geek2Jes Borland
24103509Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax62SQLDenis
2599899Collection Of Puzzles For Programmers6SQLDenis
2699337AngularJS vs Knockout - Final Thoughts (9 of 9)20Eli Weinstock-Herman (tarwn)
2795071SQL Server Query Tuning – Back to Basics3Ted Krueger (onpnt)
2890378What’s the deal with Excel & SSIS?27Koen Verbeeck
2989925SQL Server 2008 Proximity Search With The Geography Data Type50SQLDenis
3086337SQL Server Rounding Methods13George Mastros (gmmastros)
3186261Extracting numbers with SQL Server51George Mastros (gmmastros)
3285860SQL Server Configuration Manager – Remote Procedure Call Failed30Ted Krueger (onpnt)
3382483Using SpecFlow to drive Selenium WebDriver Tests14Eli Weinstock-Herman (tarwn)
3482037Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting10SQLDenis
3580495How to insert information into multiple related tables and return ID using SQLDataSource10Naomi Nosonovsky
3679018How to find what column caused the String or binary data would be truncated message13SQLDenis
3775412A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation23Jes Borland
3875220Operand type clash: date is incompatible with int error when trying to do +1 on a date data type in SQL Server 20085SQLDenis
3972658Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform27SQLDenis
4072563Trying the Stand-Up Desk41Eli Weinstock-Herman (tarwn)
4171556Dynamic column names and fields in SSRS (Custom Matrix)14Ted Krueger (onpnt)
4271551Do we need to know basic math as programmers?48SQLDenis
4371540Force installation of 64-bit ACE OLE DB provider10Koen Verbeeck
4471162SQL Server collation conflicts2George Mastros (gmmastros)
4571026Don't start your procedures with SP_15George Mastros (gmmastros)
4670882How To Enable GodMode On Windows 722SQLDenis
4770439SQL Is Hard40Eli Weinstock-Herman (tarwn)
4870151Creating a Basic Drilldown Report in SSRS 200533David Forck (thirster42)
4970084MongoDB: How to backup and restore databases2SQLDenis
5067212Showing sysjobhistory run_duration in HHMMSS format1SQLDenis