Forum Replies Created

Viewing 15 posts - 21,076 through 21,090 (of 49,552 total)

  • RE: 70-450. how deep do i need to go

    alyssajames37 (1/12/2012)

    i passed 70-450 exam and i did preparation from braindumpscity.com study material .it's good for exam preparation

    Braindumps are cheating. They are actual questions taken from the exams in violation...

    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

    January 13, 2012 at 2:07 am

    #1433068

  • RE: clone SQL server?

    Leo.Miller (1/12/2012)

    This doesn't mean everything will work as SQL can be very sensative about having her name changed.

    Most stuff works fine after a rename, replication doesn't, there's probably a few...

    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

    January 13, 2012 at 2:06 am

    #1433067

  • RE: SP_UpdateStats

    How about only updating ones that haven't just been updated (by the index rebuild)? Yes, it's more work than blanket updating everything (maintenance plan) or updating with sampled if...

    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

    January 12, 2012 at 4:26 pm

    #1432951

  • RE: SQL query performance issue.

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    January 12, 2012 at 3:41 pm

    #1432931

  • RE: 'Invalid Column Name' Error

    dcwhitson (1/12/2012)

    They were added to the new table in the new database after it was scripted. That's where I said I re-built the database manually two times, no scripting, but...

    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

    January 12, 2012 at 3:39 pm

    #1432929

  • RE: 'Invalid Column Name' Error

    That table doesn't have either of the columns bizState or bizCity.

    With that definition, the query is going to give an Invalid column error because the two columns are not 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

    January 12, 2012 at 3:26 pm

    #1432922

  • RE: 'Invalid Column Name' Error

    Can you post the CREATE TABLE statement for the Shops table please?

    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

    January 12, 2012 at 1:22 pm

    #1432858

  • RE: Timestamp column

    That's not a use at the destination, that's a use at the source (changed rows in source table). How is it going to be used in the destination table?

    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

    January 12, 2012 at 12:59 pm

    #1432851

  • RE: Timestamp column

    Typically you wouldn't retain it, it's not meaningful in the majority of cases (it's just an indication of a row being modified). Typically you'd put a timestamp/rowversion column in the...

    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

    January 12, 2012 at 12:41 pm

    #1432844

  • 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

    You can create a...

    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

    January 12, 2012 at 11:31 am

    #1432811

  • RE: Timestamp column

    SQLKnowItAll (1/12/2012)

    In SQL Server, a timestamp IS a datetime data type. So, the column you are importing into for that must be datetime data type. Does that make...

    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

    January 12, 2012 at 11:30 am

    #1432810

  • RE: Timestamp column

    Don't import the timestamp column. You can't insert into one, it's just a row version indicating which rows were latest modified, nothing more. It's not a time.

    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

    January 12, 2012 at 11:10 am

    #1432792

  • RE: Extrating Iso image

    I often burn them to DVD.

    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

    January 12, 2012 at 8:41 am

    #1432584

  • RE: What is Prod,Dev and Test servers?

    Huh? If you're maintaining 60 prod servers you should know how the databases are spread out. Or ask your senior DBA.

    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

    January 12, 2012 at 8:40 am

    #1432580

  • RE: What is Prod,Dev and Test servers?

    Many possible ways. You can replicate (not common but done), you can use a database sync tool like SQLDataCompare, you can restore the production backup each night/weekend, probably several more.

    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

    January 12, 2012 at 8:28 am

    #1432571

Viewing 15 posts - 21,076 through 21,090 (of 49,552 total)