SQL Server Code,Tips and Tricks, Performance Tuning

These were my 3 favorite sessions at the PASS Summit 2014. I attended 13 sessions and most of them, were good, some of them had a demo fa...

On twitter Adam Machanic posted a question if anyone has a document that details what a valid variable name is, what is allowed and what is ...

I noticed a stored procedure with a bit parameter and the default was false, I have never seen this before in SQL Server. You can do this i...

In case you are interested in non SQL Server related stuff, I have started a blog about non SQL stuff. You can find it here  http://denis-go...

Another year, another SQL Advent calendar has come to an end. This year there was not much SQL code after day 10, I still hope you found it ...

Just like last year, I decided to do a SQL Advent this year. There are 4 posts up so far Data types storage differences Sargable querie...

In case you missed these, here is a recap of the SQL Advent and the SQL Server 2012 posts SQL Advent Recap Day 1:  Date and time I...

This is not a technical post but I decided to spend a little of my blogging and web surfing time on my body this year...oh how vain right? O...

I have started a series of post about upgrading your skills to 2005 and 2008 versions of your code from 2000. Below is a list of posts that ...

I have created 6 new SQL Server Denali CTP3 posts These posts are about the new things introduced in SQL Server Denali CTP3, below is a list...

Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named...

Rod Colledge was kind to give the readers of Less Than Dot a chance to win a pdf copy of his book SQL Server 2008 Administration in Action ...

A buddy of mine Ted Krueger writes some really interesting SQL Server posts. Most of these posts focus more on administration than on develo...

The reason I am writing this post is that we now have RSS feeds on lessthandot for a specific author. In my case the RSS feed is the follow...

I have posted on this blog for a little over 3 years now and decided it is time to call it quits at this URL. All SQL Server related post fr...

SQL Server 2005 Service Pack 3 Beta and SQL Server 2008 Feature Pack October 2008 are available for download Download SQL Server 2005 Servic...

This was not the way I envisioned going back to Amsterdam. My mom past away today, two weeks shy of her 60th birthday Since my passport was ...

You might know that some friends and myself have launched a site named  LessThanDot , this is a site where users can collaborate via the  wi...

I interviewed Louis Davidson in 2005 about the 2005 edition of his book. I did another one today about Pro SQL Server 2008 Relational Databa...

Someone had a problem with 8 year old procs which started to fail after moving to SQL Server 2008 Of course he should have used ints, but le...