Login or Sign Up to become a member!
LessThanDot Site Logo


A Technical Community for IT Professionals

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. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "t-sql"


Book Review: Microsoft SQL Server 2012 T-SQL Fundamentals

With a basis as a system engineer, I became a DBA. And DBA’s don’t often write real DML queries. I can read a query, understand what it’s doing but when I need to read one I need BOL the help me out. Taking the 070-457 Transition Your MCTS on SQL Server…


T-SQL CASE functions

With the CASE statement you can add conditional logic to your T-SQL code. T-SQL 2012 has certain functions that can be seen as CASE shortcuts. With these functions you can quickly use some CASE functionality and as a surplus, because they are functions…


T-SQL Tuesday #31 – Logging Simple Things

How big are your core databases right now? Do you know how they got that way? Is that normal? These questions are impossible to answer just by looking at the database options dialog in SSMS. They are also questions I’ve had to try to answer in several d…


Difference between a cross join and a full outer join

We are interviewing for some SQL developer positions and it seems that most people that I interviewed do not know the difference between a full outer join and a cross join.

Cross join
A cross join produces the Cartesian product of the tables involv…


Using T-SQL OUTPUT and MERGE To Link Old and New Keys

You don’t catch me doing SQL posts that often, probably because I spend far more time working in a development world that seems to be moving further and further away from SQL. That being said, the database server is optimized towards handling large sets of data and data manipulations, so rather than second-guessing developers that know far more (and have far larger budgets), I like to take advantage of database-side solutions when I can. The time saved not dragging data back and forth on the network is an extra bonus.


How To Unpivot (and pivot) Like a Boss

Pivoting and Unpivoting data has been one of the parts of tsql that has been eluding my grasp for a while now.  I’ve seen plenty of examples for both of these, but none of those examples really helped me in understanding exactly what’s going on.


Tapping Into Your Reporting Services Database

A look into 3 SQL Server views to help manage Reporting Services Instances


RID Lookup take me down

The scenario starts with a phone call from the support desk reporting failed integrations from the ERP system to the WMS system. This integration process is critical for the production of items with the company to fulfill orders and build inventory. Without the process, finished goods inventory is not posted and thus does not become available for sale. This causes a more detrimental effect on financial reporting and filters down to the revolving reason we are in business – making money.In a normal IT team structure, there are three high-level components we all start with to troubleshoot backend systems process failures: Network, Systems/Applications and Database Server Performance. Each team sector should work together and focus on their specialty to document possibly causes. This will benefit the situation the best and also create a collaboration point where the team can compile everything found in order to proceed with the fix. As a DBA you will find yourself in this situation often and there are a couple of key points you can focus on to quickly determine if the cause is the database server. After your findings the DBA can then focus on areas to alter, tune or repair.


Checking for NULL values in all columns that allow NULLS in all the tables

This post is based on a question I answered earlier today, someone wanted to check all columns that allow NULL for NULL values in all tables. The reason people might want to do this check is that they want to make all the columns not nullable in a database (after all we all know that […]


The differences between LEN and DATALENGTH in SQL Server

The differences between LEN and DATALENGTH in SQL Server! I have seen a bunch of questions about this recently and decided to do a little post to clear up the confusion. First let’s take a look what Books On Line has to say about these two functions LEN Returns the number of characters, rather than […]

« Previous PageNext Page »