Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 49,552 total)

  • RE: Back Up Script Excluding Table

    Venki508 (2/7/2016)

    So dont we have like this export script in Sql SERVER

    expdp username/password schemas=scott exclude=table:"IN('emp','history')" directory=data_pump_dir dumpfile=test.dmp logfile=data_dump_dir:test.log

    Hugo Kornelis (2/7/2016)

    If you want to export data, e.g. to flat files 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

    February 8, 2016 at 1:38 am

    #1857074

  • RE: Simple vs. Full Backup Recovery Model

    kenny 40254 (2/7/2016)

    If I extend my "delete files" window (beyond the 3 day default) for the transactions logs to say 7 or 8 days, am I right to interpret that...

    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

    February 7, 2016 at 2:58 pm

    #1857064

  • RE: Back Up Script Excluding Table

    Take a full backup, copy it, restore, drop the tables you don't need. It'll be the fastest way of doing what you want.

    Backups are of the entire database, there's no...

    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

    February 7, 2016 at 9:01 am

    #1857045

  • RE: Back Up Script Excluding Table

    Venki508 (2/7/2016)

    Can you suggest me the tool where i can export the data into .bak file by excluding some of the tables..

    bcs some of the unnecessary tables having more than...

    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

    February 7, 2016 at 5:33 am

    #1857028

  • RE: Partitioning in sql server 2012

    Partitioning is not for performance.

    Spreading data across multiple files may give a performance improvement if the files are on separate IO subsystems and the current bottleneck is IO.

    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

    February 6, 2016 at 2:00 am

    #1856987

  • RE: Database Backup - Security Question

    DBADave (2/5/2016)

    Either way I’m not proposing folder limitations, rather tighter drive permissions.

    It would have to be permissions at a folder level. Because NTFS permissions are folder/file based with inheritance...

    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

    February 5, 2016 at 2:08 pm

    #1856963

  • RE: Alter column from datetimeoffset to datetime when index is dependent on it.

    You need to drop the index, then alter the table, then create the index again. You can't alter a column with an index on it

    That error is probably because 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

    February 5, 2016 at 2:24 am

    #1856773

  • RE: Database Backup - Security Question

    DBADave (2/4/2016)

    It's not allowing drives to be restricted. Someone doesn't need to have access to a tempdb drive to store a backup.

    How does SQL know that's a TempDB...

    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

    February 5, 2016 at 1:56 am

    #1856762

  • RE: Alter column from datetimeoffset to datetime when index is dependent on it.

    Drop the indexes, alter the column, recreate the indexes

    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

    February 5, 2016 at 1:42 am

    #1856760

  • RE: "Error: 605" then "Attempt to fetch logical page (n:nnn) in database 2 failed"

    Because it has to do with certain plan forms. Clear the plan cache and the next compile may generate a different for. It's not a fix though.

    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

    February 5, 2016 at 1:42 am

    #1856759

  • RE: Database Backup - Security Question

    DBADave (2/4/2016)

    The above statement makes me believe drive permissions get inherited from SQL Server for all backups.

    Not inherited from. SQL runs the backup operation to disk, using its service account....

    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

    February 4, 2016 at 1:07 pm

    #1856658

  • RE: Are the posted questions getting worse?

    jasona.work (2/4/2016)

    Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...

    The curiosity...

    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

    February 4, 2016 at 11:49 am

    #1856627

  • RE: Compability level

    Phil Parkin (2/4/2016)

    The difference most likely to affect you is the new cardinality estimator, in my opinion. This may mean that you need to tune some queries which previously ran...

    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

    February 4, 2016 at 6:32 am

    #1856519

  • RE: Question: Migrating from SQL 2014 to Azure SQL

    Are you moving to Azure SQL DB or to Azure VMs with SQL installed?

    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

    February 3, 2016 at 3:24 pm

    #1856425

  • RE: master thesis in sql server

    Honestly, that's something that you should be discussing with your thesis advisor, after you've done a thorough reading of the scientific literature in the area. You also need to decide...

    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

    February 3, 2016 at 2:05 pm

    #1856408

Viewing 15 posts - 3,646 through 3,660 (of 49,552 total)