Forum Replies Created

Viewing 15 posts - 586 through 600 (of 3,061 total)

  • RE: is primary key compulsary in clustering?

    vnj (1/13/2012)

    Can we fing clusters of following data?

    Id P1 P2

    x 5.6 ...

    January 16, 2012 at 9:10 am

    #1434126

  • RE: Make New Table Daily

    guerillaunit (1/16/2012)

    Can you walk me through on how to have my target server point to my linked server? What would the query syntax me for this?

    Create your linked server...

    January 16, 2012 at 9:01 am

    #1434121

  • RE: Make New Table Daily

    guerillaunit (1/16/2012)

    Hey Paul,

    I am not making a separate table for each day. Just making a new version of the same table everyday and then "pasting" over the previous day's...

    January 16, 2012 at 7:48 am

    #1434082

  • RE: Make New Table Daily

    guerillaunit (1/16/2012)

    Hi there, I have 2 database servers. I would like to take a table from one of the servers and use that table to make a new table...

    January 16, 2012 at 7:33 am

    #1434070

  • RE: my favorite normalization case study

    patrickmcginnis59 (1/13/2012)

    Long story short, I used an array of characters and a nice scrolly matrix gadget with dates across the top and students down the side, the whole matrix being...

    January 14, 2012 at 12:46 pm

    #1433742

  • RE: Normalize a SQL backend with Access 2007 front end

    kwoznica (1/14/2012)

    Dev (1/14/2012)

    Is there any particular reason for using Access Front End (except you are familiar with it)? I have used Access Front End but only if the...

    January 14, 2012 at 12:37 pm

    #1433737

  • RE: Normalize a SQL backend with Access 2007 front end

    kwoznica (1/13/2012)

    Doing it this way:

    USE GKHELPDESK

    GO

    Alter Table dbo.CaseData

    Add Constraint FK_Category_CatType Foreign Key (Category)

    References dbo.Category (ID);

    Allowed the command to complete successfully. Hopefully access will see it.

    Technically there is nothing for Access...

    January 13, 2012 at 3:55 pm

    #1433586

  • RE: DR Solution

    csuresh79 (1/12/2012)

    Thanks.. Do you see any other issues in copying system databases from Clustered to Standalone.?

    Well... I do not know.

    I been told it works fine between two standalone instance where...

    January 12, 2012 at 12:45 pm

    #1432846

  • RE: DR Solution

    csuresh79 (1/12/2012)

    We have a production server which is 2 node cluster. DR is proposed to have stand alone machine, with SRDF solution for SAN replication.

    I'm not sure how these...

    January 12, 2012 at 11:51 am

    #1432821

  • RE: Dropping Image column

    george sibbald (1/12/2012)

    @paul-2 - please read the first 3 posts - this might HAVE to be a drop column and I need to be prepared for that.

    I appreciate the intention...

    January 12, 2012 at 11:38 am

    #1432819

  • RE: Timestamp column

    svakka (1/12/2012)

    Thank you all .My source column has timestamp data type, should I create rowversion, date time data type to hold the same value as in source

    Would you mind in...

    January 12, 2012 at 11:21 am

    #1432806

  • RE: Dropping Image column

    george sibbald (1/12/2012)

    PaulB-TheOneAndOnly (1/12/2012)

    george sibbald (1/12/2012)

    If your t-log has space for a 7.5 million rows insert query you should be fine.

    well yes, obviously, but how much space is that? Very...

    January 12, 2012 at 11:19 am

    #1432803

  • RE: Dropping Image column

    george sibbald (1/12/2012)

    Gianluca Sartori (1/12/2012)

    Lowell (1/12/2012)

    for something similar, we've created the parallel table without the image column, migrated the data, then renamed the old vs new table, and after we...

    January 12, 2012 at 11:10 am

    #1432793

  • RE: Dropping Image column

    george sibbald (1/12/2012)

    If your t-log has space for a 7.5 million rows insert query you should be fine.

    well yes, obviously, but how much space is that? Very much an 'it...

    January 12, 2012 at 11:03 am

    #1432784

  • RE: Database views to support Cube.

    aaa-322853 (1/10/2012)

    Personally I think the use of views in a OLAP environment is fundamental to a flexible design.

    Not only does it provide a layer of abstraction but crucially it helps...

    January 12, 2012 at 11:02 am

    #1432782

Viewing 15 posts - 586 through 600 (of 3,061 total)