Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day


  • 6
    Liked
    0
    Learned
    13
    Comments

    How to split string efficently

    It's quite old, but new for me. Great method to parse string is using of recursive CTE, as showed in Table Function: CREATE FUNCTION fn_SplitString(@str NVARCHAR(MAX), @sep NVARCHAR(MAX)) RETURNS TABLE AS RETURN ( WITH sepPos ...
    SQL Server Tips
    Adam Tokarski  Posted on Mar 9 2012 12:00AM
  • 17
    Liked
    10
    Learned
    12
    Comments

    Get random row from the table

    Sometimes it happens that we need random row (or set of randoms rows) from table. Itzik Ben-Gan shows us, in one of his book, the efficient way to do this: SELECT TOP(1) * FROM someTable ORDER BY NEWID() Changing the value in TOP operator, we can, in...
    SQL Server Tips
    Adam Tokarski  Posted on Feb 21 2012 12:00AM
  • 45
    Liked
    43
    Learned
    12
    Comments

    SQL Server - IN Clause works the other way, too!

    The IN clause in T-SQL can be used to find a single value present in any one of multiple supplied columns. For example, in the AdventureWorks database: [code] SELECT Title, FirstName, MiddleName, LastName, Suffix FROM Person.Contact WHERE 'Lee' I......
    SQL Server Tips
    Jeffem  Posted on Sep 24 2011 11:34AM
    Last reply by Naresh Yadav at 2015-01-20 11:12:51
  • 16
    Liked
    16
    Learned
    12
    Comments

    Top 10 Largest Databases in the World

    Just learned from focus.com's Editors article.In that they have identified Top 10 Largest Databases in the World, Here we have the list. I)The Library of Congress (LC) boasts more than 130 million items ranging from cook books to colonial newspapers ......
    SQL Server Tips
    Robert Dennyson  Posted on Jul 1 2011 11:57AM
    Last reply by desperadomar at 2013-12-14 08:30:27
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]