Forum Replies Created

Viewing 15 posts - 10,951 through 10,965 (of 49,552 total)

  • RE: Multiple Data Files

    Are they all in the same filegroup?

    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

    November 14, 2013 at 1:38 am

    #1666281

  • RE: Indexes

    Don't create indexes blindly off missing index DMV, you'll end up with massive numbers of duplicates and a large pile of useless indexes. Evaluate any suggestions made, implement if they're...

    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

    November 13, 2013 at 11:45 pm

    #1666273

  • RE: nolock option

    Same as the read uncommitted isolation level. Request no shared locks for the hinted tables thus allowing dirty reads. Additionally it allows allocation order scans (reads in physical order instead...

    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

    November 13, 2013 at 10:08 pm

    #1666269

  • RE: Concat columns in Where clause

    LutzM (11/13/2013)

    But for the taks itself (taking aside the concatenation) your preferred solution is NOT EXISTS?

    Is this "usually" the fastest solution for a large table against a small lookup 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

    November 13, 2013 at 11:42 am

    #1666172

  • RE: Concat columns in Where clause

    LutzM (11/13/2013)

    GilaMonster (11/13/2013)

    Jonathan Marshall (11/12/2013)

    The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

    I like that idea of using...

    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

    November 13, 2013 at 10:22 am

    #1666151

  • RE: Concat columns in Where clause

    Jonathan Marshall (11/12/2013)

    The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

    I like that idea of using a computed...

    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

    November 13, 2013 at 7:57 am

    #1666091

  • RE: NT AUTHORITY\SYSTEM

    Not database set to single user mode. Instance started in single user 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

    November 13, 2013 at 7:11 am

    #1666067

  • RE: NT AUTHORITY\SYSTEM

    So have you checked the logs and proven that he did that? If you haven't, then you can't assume.

    Check what logins you have. Make sure you haven't granted local administrators...

    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

    November 13, 2013 at 6:57 am

    #1666056

  • RE: Error while database backup

    Please post new questions in a new thread.

    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

    November 13, 2013 at 6:55 am

    #1666053

  • RE: NT AUTHORITY\SYSTEM

    Beatrix Kiddo (11/13/2013)

    (or he restarted SQL Server in single user mode)

    Can this be used as a way to get access if you don't know any of the passwords? I definitely...

    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

    November 13, 2013 at 6:54 am

    #1666052

  • RE: NT AUTHORITY\SYSTEM

    Beatrix Kiddo (11/13/2013)

    Hi. Sorry if this is a bit of a silly question, but how can I find out what minimum permissions I need to give the NT AUTHORITY\SYSTEM account?

    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

    November 13, 2013 at 6:42 am

    #1666044

  • RE: Database on emergency mode

    What happened, why is the database in Emergency mode?

    And do you have your backups handy?

    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

    November 13, 2013 at 6:39 am

    #1666040

  • RE: How to measure the duration of a full table scan?

    select count(*) from table WITH (INDEX=0)

    That'll force a table scan instead of the usual scan of the smallest index that the optimiser prefers.

    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

    November 13, 2013 at 6:02 am

    #1666021

  • RE: DB Offline

    The default trace doesn't keep data forever. It keeps 5 files of max 20MB each. Could be the files have rolled over and the date of the alter database is...

    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

    November 13, 2013 at 6:01 am

    #1666020

  • RE: Truncate / Shrink Log for Mirrored Databse

    Don't shrink to too small a size. Is 1GB enough for the regular operations on your database? If not, don't shrink that small.

    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

    November 13, 2013 at 4:00 am

    #1665993

Viewing 15 posts - 10,951 through 10,965 (of 49,552 total)