Forum Replies Created

Viewing 15 posts - 541 through 555 (of 758 total)

  • RE: Windows 2008 Cluster - Install SQL

    RaviTeja Gullapalli (6/6/2012)

    Which rule is failing in the Setup support rules ?

    Cluster Verification errors? or Warnings ? Can you send me a screenshot to rgullapalli3@live.com ?

    According to the Log it's...

    June 6, 2012 at 6:55 am

    #1497587

  • RE: Windows 2008 Cluster - Install SQL

    SQLCrazyCertified (6/6/2012)

    SQLSACT (6/6/2012)

    Hi All

    I have a working 2008 Windows 2 node Cluster. No clustered applications have been installed yet

    I need to install SQL Server on this cluster

    When I run the...

    June 6, 2012 at 6:27 am

    #1497571

  • RE: Windows 2008 Cluster - Install SQL

    bipan (6/6/2012)

    you still need to run the SQL Installation Add Node on the other node to put binaries.

    Thanks

    June 6, 2012 at 3:26 am

    #1497490

  • RE: Joins

    Grant Fritchey (5/25/2012)

    When you're defining a join, you should define the columns that join the two tables together. So that you're ON condition is something along the lines of

    A.ID...

    May 25, 2012 at 11:20 am

    #1493308

  • RE: Backward Compatibility

    ScottPletcher (5/24/2012)

    User dbs will definitely work ok to a later SP.

    Master will definitely NOT work; master MUST be to the same version.

    Not sure about msdb, but apparently same rules apply...

    May 24, 2012 at 12:24 pm

    #1492716

  • RE: Backward Compatibility

    cfradenburg (5/24/2012)

    derekr 43208 (5/24/2012)

    I'm just trying to fish out whether backward compatibility exists between Service Packs

    Try doing it with a user DB. It sounds like system DBs may behave...

    May 24, 2012 at 10:57 am

    #1492688

  • RE: Backward Compatibility

    Perry Whittle (5/24/2012)

    derekr 43208 (5/24/2012)

    Hi all

    I know that SQL Server is backward compatible - I can restore a 2005 Database into a 2008 instance.

    Is this possible between Service Packs?

    Can...

    May 24, 2012 at 10:52 am

    #1492682

  • RE: Exists

    Lynn Pettis (5/23/2012)

    derekr 43208 (5/23/2012)

    Yes. As I explained earlier, the first query has a correlated subquery in the EXISTS predicate. This query is run for each row in...

    May 23, 2012 at 12:24 pm

    #1492030

  • RE: Exists

    Yes. As I explained earlier, the first query has a correlated subquery in the EXISTS predicate. This query is run for each row in the outer table returning...

    May 23, 2012 at 11:54 am

    #1492006

  • RE: Exists

    Lynn Pettis (5/23/2012)

    Your query:

    select

    *

    from

    T1 TT

    where

    exists (select

    ...

    May 23, 2012 at 11:24 am

    #1491980

  • RE: Exists

    Sean Lange (5/23/2012)

    See if this wiki article will help in your understanding. Not a very in depth look but it may help you get what is going on.

    http://en.wikipedia.org/wiki/Correlated_subquery

    Thanks

    I'm trying to...

    May 23, 2012 at 10:59 am

    #1491950

  • RE: Exists

    Lynn Pettis (5/23/2012)

    Your query:

    select

    *

    from

    T1 TT

    where

    exists (select

    ...

    May 23, 2012 at 10:44 am

    #1491933

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/21/2012)

    derekr 43208 (5/21/2012)

    This is where I am a bit confused....

    For AG's, all nodes must be part of the same cluster but with seperate storage?

    For HA Instances all nodes...

    May 21, 2012 at 6:48 am

    #1490392

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/21/2012)

    derekr 43208 (5/21/2012)

    This is where I am a bit confused....

    For AG's, all nodes must be part of the same cluster but with seperate storage?

    For HA Instances all nodes...

    May 21, 2012 at 6:40 am

    #1490385

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/21/2012)

    This is already detailed in my previous replies, but

    derekr 43208 (5/21/2012)

    does each node need to be part of the same cluster?

    For availability groups, yes, all nodes need to...

    May 21, 2012 at 4:50 am

    #1490331

Viewing 15 posts - 541 through 555 (of 758 total)