LessThanDot Site Logo

LessThanDot

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


1. Cumulative Update 1 to the RML Utilities for Microsoft SQL Server Released
Views : 3394051
Comments : 0
By : SQLDenis



2. Upgrade Assistant for SQL Server 2012 available for download
Views : 2003189
Comments : 0
By : SQLDenis



3. SQL Server Code Name “Denali” CTP3 Product Guide available for download
Views : 1681228
Comments : 0
By : SQLDenis



4. Scripting all jobs on SQL Server 2005/2008 into one file
Views : 358516
Comments : 7
By : SQLDenis



5. Always include precision and scale with decimal and numeric
Views : 332724
Comments : 8
By : George Mastros (gmmastros)



6. Do not use spaces or other invalid characters in your column names
Views : 290778
Comments : 14
By : George Mastros (gmmastros)



7. Watch all the Tech·Ed North America 2011 SQL Server videos
Views : 276082
Comments : 5
By : SQLDenis



8. Calculating Mean, Median and Mode with SQL Server
Views : 224157
Comments : 27
By : George Mastros (gmmastros)



9. Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters
Views : 179258
Comments : 14
By : SQLDenis



10. Missing foreign key constraints
Views : 158587
Comments : 8
By : George Mastros (gmmastros)



11. SQL Server Zipcode Latitude/Longitude proximity distance search
Views : 155536
Comments : 85
By : George Mastros (gmmastros)



12. Stupid me #3 – Building the script component
Views : 152742
Comments : 0
By : Koen Verbeeck



13. SQL Server Filegroup Piecemeal Restores
Views : 146394
Comments : 6
By : Jes Borland



14. Always include size when using varchar, nvarchar, char and nchar
Views : 134161
Comments : 4
By : George Mastros (gmmastros)



15. How to get information about all databases without a loop
Views : 132243
Comments : 30
By : Naomi Nosonovsky



16. The Ten Most Asked SQL Server Questions And Their Answers
Views : 130596
Comments : 56
By : SQLDenis



17. Tips and Tricks to Make SQL Server Management Studio Awesome
Views : 127658
Comments : 44
By : Jes Borland



18. Free ASP.NET MVC eBook Tutorial in pdf format
Views : 125972
Comments : 5
By : SQLDenis



19. 6 ways to import data into SQL Server
Views : 121402
Comments : 19
By : Ted Krueger (onpnt)



20. SQL Server Types - Numeric vs Int
Views : 113888
Comments : 14
By : Eli Weinstock-Herman (tarwn)



21. SQL Server DBA Tip 15 – SQL Server Agent – Job ownership
Views : 113419
Comments : 1
By : Ted Krueger (onpnt)



22. How I prepared myself for the MCSE certification
Views : 106165
Comments : 36
By : Koen Verbeeck



23. T-SQL Tuesday 32: A Day in the Life a Grrl Geek
Views : 106100
Comments : 2
By : Jes Borland



24. Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax
Views : 103509
Comments : 62
By : SQLDenis



25. Collection Of Puzzles For Programmers
Views : 99899
Comments : 6
By : SQLDenis



26. AngularJS vs Knockout - Final Thoughts (9 of 9)
Views : 99337
Comments : 20
By : Eli Weinstock-Herman (tarwn)



27. SQL Server Query Tuning – Back to Basics
Views : 95071
Comments : 3
By : Ted Krueger (onpnt)



28. What’s the deal with Excel & SSIS?
Views : 90378
Comments : 27
By : Koen Verbeeck



29. SQL Server 2008 Proximity Search With The Geography Data Type
Views : 89925
Comments : 50
By : SQLDenis



30. SQL Server Rounding Methods
Views : 86337
Comments : 13
By : George Mastros (gmmastros)



31. Extracting numbers with SQL Server
Views : 86261
Comments : 51
By : George Mastros (gmmastros)



32. SQL Server Configuration Manager – Remote Procedure Call Failed
Views : 85860
Comments : 30
By : Ted Krueger (onpnt)



33. Using SpecFlow to drive Selenium WebDriver Tests
Views : 82483
Comments : 14
By : Eli Weinstock-Herman (tarwn)



34. Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting
Views : 82037
Comments : 10
By : SQLDenis



35. How to insert information into multiple related tables and return ID using SQLDataSource
Views : 80495
Comments : 10
By : Naomi Nosonovsky



36. How to find what column caused the String or binary data would be truncated message
Views : 79018
Comments : 13
By : SQLDenis



37. A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation
Views : 75412
Comments : 23
By : Jes Borland



38. Operand type clash: date is incompatible with int error when trying to do +1 on a date data type in SQL Server 2008
Views : 75220
Comments : 5
By : SQLDenis



39. Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform
Views : 72658
Comments : 27
By : SQLDenis



40. Trying the Stand-Up Desk
Views : 72563
Comments : 41
By : Eli Weinstock-Herman (tarwn)



41. Dynamic column names and fields in SSRS (Custom Matrix)
Views : 71556
Comments : 14
By : Ted Krueger (onpnt)



42. Do we need to know basic math as programmers?
Views : 71551
Comments : 48
By : SQLDenis



43. Force installation of 64-bit ACE OLE DB provider
Views : 71540
Comments : 10
By : Koen Verbeeck



44. SQL Server collation conflicts
Views : 71162
Comments : 2
By : George Mastros (gmmastros)



45. Don't start your procedures with SP_
Views : 71026
Comments : 15
By : George Mastros (gmmastros)



46. How To Enable GodMode On Windows 7
Views : 70882
Comments : 22
By : SQLDenis



47. SQL Is Hard
Views : 70439
Comments : 40
By : Eli Weinstock-Herman (tarwn)



48. Creating a Basic Drilldown Report in SSRS 2005
Views : 70151
Comments : 33
By : David Forck (thirster42)



49. MongoDB: How to backup and restore databases
Views : 70084
Comments : 2
By : SQLDenis



50. Showing sysjobhistory run_duration in HHMMSS format
Views : 67212
Comments : 1
By : SQLDenis