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?"

    https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    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

    AGE=24

    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)