Forum Replies Created

Viewing 15 posts - 10,381 through 10,395 (of 49,552 total)

  • RE: TDE Enable???

    You mean 'database properties'? (there is no options tab, nor any encryption option on the server setting)

    Enabling TDE encrypts the database and backups so they cannot be restored or attached...

    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 16, 2014 at 7:40 am

    #1680658

  • RE: how to set up transaction logs on local disk in cluster server sql server 2008

    On shared storage unless you make some unsupported hack (which I am not going to explain).

    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 16, 2014 at 7:37 am

    #1680654

  • RE: DB_DB_INDEX_PHYSLCAL_STATS returning wrong indexes and table functions?

    You're passing NULL as the first parameter so the query is checking all indexes on all tables in all databases on the instance. Look at the database ID that 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 16, 2014 at 7:36 am

    #1680653

  • RE: how to set up transaction logs on local disk in cluster server sql server 2008

    Database files must be on shared storage when you have a clustered SQL Server.

    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 16, 2014 at 6:59 am

    #1680637

  • RE: How to reduce the Index Seek cost ? my index seek is taking 87% ?

    First things first. Is that a problem? Is that query a problem?

    If not, why are you worrying about it? The % cost has to be somewhere, it is 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 16, 2014 at 6:43 am

    #1680622

  • RE: Database Restore

    Restore the last full backup

    Restore the 1pm differential

    Restore all the log backups since that diff.

    Whether or not you can recover that 55 minutes since the last log backup depends...

    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 16, 2014 at 5:32 am

    #1680608

  • RE: delete from table based on where exists

    spin (1/16/2014)

    a media event is created which has accountId, stockId, startDate, endDate. (it also has some other details about the event).

    after insert, delete, update i need

    1) to calculate 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 16, 2014 at 5:22 am

    #1680604

  • RE: Database Restore

    Restore the last full backup (see books online - the SQL help file - for the RESTORE syntax)

    Restore the 1pm differential

    Restore all the log backups since that diff. You didn'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

    January 16, 2014 at 5:21 am

    #1680603

  • RE: delete from table based on where exists

    This is what's causing the errors

    where MediaId = (select MediaId from inserted))

    When you delete multiple rows, there are multiple rows in inserted (it's not a for each row trigger)...

    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 16, 2014 at 4:25 am

    #1680585

  • RE: delete from table based on where exists

    If you can post the trigger code, we can probably get it to behave properly.

    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 16, 2014 at 3:29 am

    #1680570

  • RE: delete from table based on where exists

    Abu Dina (1/16/2014)

    No. It knows exactly which ones to delete.

    Does it?

    Yes. Any row for which the EXISTS predicate evaluates to TRUE.

    Now, if you don't use a join, that'll 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

    January 16, 2014 at 3:03 am

    #1680568

  • RE: find the count of rows all tables based on created date

    Count of all tables meaning what? Number of tables where something to do with created date parameter? Number of rows in those tables with something to do with created date...

    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 16, 2014 at 2:28 am

    #1680565

  • RE: delete from table based on where exists

    Abu Dina (1/15/2014)

    Your first query is returning two columns: a.AccountId, b.StockId

    Then your delete is using the EXISTS operator which is fair enough but the inner query returns multiple rows...

    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 16, 2014 at 2:09 am

    #1680560

  • RE: find the count of rows all tables based on created date

    Based on created date of what?

    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 16, 2014 at 12:36 am

    #1680530

  • RE: Profiler Trace: finding Stored Procedures that are slow(est) and resource-consuming

    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    Because for example, for ONE RECORD for RPC:Completed event there may be 3 records for SP:StmtCompleted event, right?

    Yes, so the question is, why are you tracing both if that problem...

    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 16, 2014 at 12:33 am

    #1680529

Viewing 15 posts - 10,381 through 10,395 (of 49,552 total)