Search results matching tags 'SQL', 'Forum', and 'Hacks'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL,Forum,Hacks&orTags=0Search results matching tags 'SQL', 'Forum', and 'Hacks'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Less Than Dot A New Community Site Has Been Launchedhttp://sqlblog.com/blogs/denis_gobo/archive/2008/06/02/7104.aspxMon, 02 Jun 2008 14:12:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:7104Denis Gobo<DIV class=content>So finally I have something to announce!</DIV>
<DIV class=content>&nbsp;</DIV>
<DIV class=content>Myself and a bunch of friends have been working on <A href="http://www.lessthandot.com/">Less Than Dot</A>&nbsp;for a while now. The site has a <A href="http://forum.lessthandot.com/">forum</A>, <A href="http://blogs.lessthandot.com/">blogs</A>&nbsp;and a <A href="http://wiki.lessthandot.com/">wiki</A>. More info why we started <A href="http://www.lessthandot.com/">Less Than Dot</A>&nbsp;and who we are can be found here: <A href="http://www.lessthandot.com/aboutus.php">http://www.lessthandot.com/aboutus.php</A><BR></DIV>
<DIV class=content>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&nbsp;which I and some of the co-founders answer over and over again.&nbsp;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. </DIV>
<DIV class=content>&nbsp;</DIV>
<DIV class=content><SPAN style="FONT-WEIGHT:bold;">SQL Server Hacks </SPAN><SPAN style="FONT-WEIGHT:bold;">Sections</SPAN> </DIV>
<DIV class=content>* 1 NULLS </DIV>
<DIV class=content>* 2 Dates </DIV>
<DIV class=content>* 3 Sorting, Limiting Ranking, Transposing and Pivoting </DIV>
<DIV class=content>* 4 Handy tricks </DIV>
<DIV class=content>* 5 Pitfalls </DIV>
<DIV class=content>* 6 Query Optimization </DIV>
<DIV class=content>* 7 Undocumented but handy </DIV>
<DIV class=content>* 8 Usefull Admin stuff For The Developer </DIV>
<DIV class=content>&nbsp;</DIV>
<DIV class=content>Below are some direct links to a couple hacks, you can also get a list of all the hacks on the wiki itself here: <A href="http://wiki.lessthandot.com/index.php/SQL_Server_Programming_Hacks_-_100%2B_List">SQL Server Programming Hacks</A><BR></DIV>
<DIV class=content>
<UL style="TEXT-ALIGN:left;"><A href="http://wiki.lessthandot.com/index.php/Trouble_With_ISDATE_And_Converting_To_SMALLDATETIME"><SPAN>Trouble With ISDATE And Converting To SMALLDATETIME</SPAN></A><BR><A href="http://wiki.lessthandot.com/index.php/Row_To_Column_%28PIVOT%29">Row To Column (PIVOT)</A><BR><A href="http://wiki.lessthandot.com/index.php/Column_To_Row_%28UNPIVOT%29">Column To Row (UNPIVOT)</A><BR><SPAN><A href="http://wiki.lessthandot.com/index.php/5_ways_to_return_rows_from_one_table_not_in_another_table">Five ways to return all rows from one table which are not in another table</A><BR></SPAN><SPAN><A href="http://wiki.lessthandot.com/index.php/Order_IP_Addresses">Order IP Addresses</A><BR></SPAN><A href="http://wiki.lessthandot.com/index.php/Use_XACT_STATE%28%29_To_Check_For_Doomed_Transactions"><SPAN>Use XACT_STATE() To Check For Doomed Transactions</SPAN></A><BR><SPAN><A href="http://wiki.lessthandot.com/index.php/Three_differences_between_COALESCE_and_ISNULL">Three differences between COALESCE and ISNULL</A><BR></SPAN><SPAN><A href="http://wiki.lessthandot.com/index.php/SQL_Server_Programming_Hacks_-_Case_Sensitive_Search">Case sensitive search</A><BR></SPAN><A href="http://wiki.lessthandot.com/index.php/Use_the_sys.dm_db_index_usage_stats_dmv_to_check_if_indexes_are_being_used">Use the sys.dm_db_index_usage_stats dmv to check if indexes are being used</A></UL></DIV>
<UL style="TEXT-ALIGN:left;"><BR></UL>
<P>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: <A href="http://sqlblog.com/forums/default.aspx">http://sqlblog.com/forums/default.aspx</A>)</P>
<P>And don't worry I will still do my SQL blogging here :-)</P>