Forum Replies Created

Viewing 15 posts - 6,361 through 6,375 (of 49,552 total)

  • RE: Data fetching 80 million records ??

    Please post the query that you're using and all the indexes on the 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

    March 24, 2015 at 4:37 am

    #1785909

  • RE: Restore DB1 to DB2 (with different filegroups and files structure)

    You can't do it with a backup/restore. A restore recreates the database as it was at the time of backup, identical files. Restore the DB and then add the new...

    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

    March 24, 2015 at 4:13 am

    #1785901

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/23/2015)

    I think the point I was trying to make has been missed.....

    I was going to say something similar, but decided against it. Then a friend posted a blog...

    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

    March 24, 2015 at 3:01 am

    #1785890

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (3/22/2015)

    Now where is the Crystal Ball?

    😎

    If you find it, I think this query can only be done if the WITH (CrystalBall) join hint is used.

    http://www.sqlservercentral.com/Forums/Topic1670606-391-1.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

    March 23, 2015 at 8:07 am

    #1785706

  • RE: Inner Join With Complex Condition

    pradeep.joy21 (3/23/2015)

    for your reference I have one more column in @child table named as childMasterID where associated masterid in master tables will be inserted accordingly

    And we were supposed to...

    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

    March 23, 2015 at 7:45 am

    #1785697

  • RE: Inner Join With Complex Condition

    Why should the two negative values not appear in the results?

    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

    March 23, 2015 at 6:19 am

    #1785671

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (3/22/2015)

    Now where is the Crystal Ball?

    😎

    Don't think it's going to help much

    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

    March 23, 2015 at 2:43 am

    #1785636

  • RE: How to update certain column from all tables within DB?

    An update statement can affect one and only one table. If you have to update values in 30 tables, you need 30 update statements. You can use something like foreachDB...

    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

    March 20, 2015 at 8:10 am

    #1785356

  • RE: Unique Index

    CREATE UNIQUE INDEX <index name> on <Table Name> (<Column1>, <Column2>)

    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

    March 20, 2015 at 7:05 am

    #1785331

  • RE: Dynamic Partitioning

    Why are you considering partitioning?

    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

    March 20, 2015 at 6:21 am

    #1785318

  • RE: Cross Apply error

    renato.mgomes (3/20/2015)

    hello, i execute the script and the result was 80

    Cross Apply didn't exist in SQL Server 2000 and it doesn't work if a database is set to compatibility mode...

    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

    March 20, 2015 at 4:26 am

    #1785300

  • RE: How to update certain column from all tables within DB?

    An update statement can only affect a single table. Hence to update multiple tables you need multiple update statements

    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

    March 20, 2015 at 2:36 am

    #1785287

  • RE: db reader and deny

    Deny overrules grant, so if you add someone to db_datareader and db_denydatareader, they will not be able to read anything.

    As for db_owner, test and see. (can't recall offhand whether db_owner...

    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

    March 20, 2015 at 2:34 am

    #1785285

  • RE: Read Committed Snapshot.

    Yes, and?

    Read committed doesn't mean no blocking. It means that readers don't block writers, that's all.

    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

    March 19, 2015 at 10:41 am

    #1785155

  • RE: help left join

    ichayan2003 (3/19/2015)

    As per link the is null clause on the where clause for the lookup columns worked fine. But this works only if is null clause returns no. In case...

    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

    March 19, 2015 at 10:40 am

    #1785153

Viewing 15 posts - 6,361 through 6,375 (of 49,552 total)