Less Than Dot A New Community Site Has Been Launched

Denis Gobo — Mon, 02 Jun 2008 14:12:00 GMT

So finally I have something to announce!

Myself and a bunch of friends have been working on Less Than Dot for a while now. The site has a forum, blogs and a wiki. More info why we started Less Than Dot and who we are can be found here: http://www.lessthandot.com/aboutus.php

Since I am mostly a SQL guy, I wrote a collection of SQL Server hacks. These hacks are basically a collection of frequently asked questions which I and some of the co-founders answer over and over again. This collection of SQL hacks is available on the Wiki, right now we have 8 sections and between 70 and 80 hacks. Ideally we will have more hacks and we will also have a SQL admin hacks page in the future.

SQL Server Hacks Sections

* 1 NULLS

* 2 Dates

* 3 Sorting, Limiting Ranking, Transposing and Pivoting

* 4 Handy tricks

* 5 Pitfalls

* 6 Query Optimization

* 7 Undocumented but handy

* 8 Usefull Admin stuff For The Developer

Below are some direct links to a couple hacks, you can also get a list of all the hacks on the wiki itself here: SQL Server Programming Hacks

Trouble With ISDATE And Converting To SMALLDATETIME

Row To Column (PIVOT)

Column To Row (UNPIVOT)

Five ways to return all rows from one table which are not in another table

Order IP Addresses

Use XACT_STATE() To Check For Doomed Transactions

Three differences between COALESCE and ISNULL

Case sensitive search

Use the sys.dm_db_index_usage_stats dmv to check if indexes are being used

Hopefully you will like the site and find some good content, if you have a question then don't hesitate to ask it in a forum (if it is a SQL question then ask here first: http://sqlblog.com/forums/default.aspx)

And don't worry I will still do my SQL blogging here :-)

Search results matching tags 'SQL', 'Forum', and 'Hacks'

Less Than Dot A New Community Site Has Been Launched