Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Max DB Size for SQL Server Express

    There is error in answer.

    "What is the maximum relational database size of the SQL Server 2014 edition can grow to?"

    Maximum relational Database size = 524 PB

    There isn't word...

  • RE: Parameter sniffing

    Mikael Eriksson SE (10/17/2013)

    It is the same in SQL Server 2005, 2008 and 2012.

    If you want to check what the compiled value is you can use this.


    Thanks. Very interesting!

  • RE: Accurate Computation of Age

    It doesn't work correctly

    martinez.math (11/16/2012)

    Example 2

    DOB = 11/14/1987 and

    datenow =11/15/2012 the result would be


    should be AGE=25

    but your code returns 24 (:

    p.s. It computes my age incorrect 🙁

  • RE: Avoiding IF/ELSE

    You could think about something like this:

    SELECT Comp.*

    FROM #Companies AS Comp

    LEFT JOIN #CompanyGroups AS Gr ON Comp.CompanyID = Gr.CompanyID

    WHERE Comp.CompanyID = @CompanyID

    OR GR.CompanyGroupID = @CompanyGroupID

  • RE: Avoiding IF/ELSE

    Additional questions. What results should be for this?

    CREATE TABLE #Companies (CompanyID int)

    INSERT INTO #Companies (CompanyID) VALUES (1)

    INSERT INTO #Companies (CompanyID) VALUES (2)

    INSERT INTO #Companies (CompanyID) VALUES (3)

    CREATE TABLE #CompanyGroups (CompanyGroupID...

Viewing 5 posts - 1 through 5 (of 5 total)