Forum Replies Created

Viewing 15 posts - 31,996 through 32,010 (of 49,552 total)

  • RE: SQL on Remote Server, via Mapped Drive ?

    No. It won't even work.

    SQL has a lot of rules about where it can create files for database and network shares are disqualified by those rules. There is a traceflag...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 10:45 am

    #1188620

  • RE: tablename in trigger

    I would strongly recommend that you don't create a general trigger. You'll end up doing a lot of work to compute the column names, you may or may not be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 8:40 am

    #1188614

  • RE: mirror , replicate or else....?

    Then you can't use transactional or merge replication (merge adds columns). Mirroring won't allow you to add views to the destination, nor will log shipping.

    You're limited to snapshot replication -...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 8:35 am

    #1188613

  • RE: while alter a table it should say that column already related to some views.

    Create the view WITH SCHEMABINDING, or you can implement a custom DDL trigger that checks dependencies and throws an error. The first is far easier

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 6:22 am

    #1188610

  • RE: mirror , replicate or else....?

    Straightforward transactional replication. Set it up with the wizards in Management Studio (no easier way), create the views on the subscriber afterwards.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 3:30 am

    #1188605

  • RE: How to convert int primary key to uniqueidentifier

    Why, why, why do you want uniqueidentifiers? My advice is safe as Jeff's. Don't.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 3:24 am

    #1188603

  • RE: what is the use of tempdb in sql server 2005

    Did you try a search before asking?

    http://msdn.microsoft.com/en-us/library/ms190768%28v=SQL.90%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 4, 2010 at 3:16 am

    #1188601

  • RE: What columns are eligible to be in non clustered index

    xzd000 (7/3/2010)

    GilaMonster (7/3/2010)

    Jeff Moden (7/3/2010)

    What does affect non-clustered indexes is whether or not a clustered index exists.

    And even then it just affects the internal structure of the index, not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 12:21 pm

    #1188564

  • RE: What columns are eligible to be in non clustered index

    Jeff Moden (7/3/2010)

    What does affect non-clustered indexes is whether or not a clustered index exists.

    And even then it just affects the internal structure of the index, not how you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 12:10 pm

    #1188561

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/3/2010)

    However it is some work, and it helps if you find 3-4 people to each do a part.

    Considering the success (not) I've been having in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:38 am

    #1188555

  • RE: What columns are eligible to be in non clustered index

    p.p.s. The limitation on indexable columns is clearly laid out in Books Online.

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:31 am

    #1188552

  • RE: What columns are eligible to be in non clustered index

    p.s. Tell the interviewer that this is a stupid question.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:29 am

    #1188550

  • RE: What columns are eligible to be in non clustered index

    xzd000 (7/3/2010)

    The emphasis is that - The table does not have primary key column. Does that fact affect the creation of non clustered index in any way?

    No. The presence...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:27 am

    #1188549

  • RE: What columns are eligible to be in non clustered index

    xzd000 (7/3/2010)

    If a table has 5 columns , which are not primary, then how many non clustered indexes cam be created for that table?

    Can be or...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:24 am

    #1188546

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/3/2010)

    A full day pre-con is 6 hours. Not a huge stretch if you've done 4, could be hard if you've never done more than 2. However,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 3, 2010 at 11:17 am

    #1188542

Viewing 15 posts - 31,996 through 32,010 (of 49,552 total)