Forum Replies Created

Viewing 15 posts - 9,286 through 9,300 (of 49,552 total)

  • RE: SORT_IN_TEMPDB

    yuvipoy (4/16/2014)

    Will it improve my query performance?

    Say where condition is index column which is "SORT_IN_TEMPDB" option

    No.

    The option affects where SQL allocated sort space during and only during an index...

    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

    April 16, 2014 at 2:49 am

    #1706355

  • RE: Restore Database statement - any way to exclude the stored procs?

    No.

    A restore over an existing database is equivalent to dropping the old DB and replacing it. It's not a merge, SQL discards the existing DB and completely replaces it with...

    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

    April 16, 2014 at 2:45 am

    #1706352

  • RE: Truncate and Restores

    In that case, I'll take it. Won't be this month though. Is that OK?

    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

    April 16, 2014 at 2:38 am

    #1706347

  • RE: how to make use of tempdb in sql server 2000

    It's used for temp tables, table variables, sort and hash spills (which you generally don't want because they're slower than hash/sort done in memory) and for work tables which 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

    April 16, 2014 at 2:35 am

    #1706346

  • RE: How to Get the Column Used in where condition in a Procedure

    Short of writing a SQL parser in T-SQL, probably not.

    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

    April 16, 2014 at 2:28 am

    #1706342

  • RE: data file movement

    ALTER DATABASE ... MODIFY FILE, set the new name. Take the DB offline. Copy the files to their new location, ensure SQL has permission on the folder, bring DB online.

    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

    April 15, 2014 at 10:29 am

    #1706176

  • RE: Read response time Transaction Log

    Transactional replication, change data capture, mirroring, availability groups, log backups, full/diff backups, transaction rollbacks all read from the log.

    Could be the writes to the log from the rebuild have 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

    April 15, 2014 at 9:10 am

    #1706149

  • RE: Enabling LPIM and AWE

    george sibbald (4/15/2014)

    16GB is probably a tad conservative but a good starting point.

    Personally I like conservative, it reduces unpleasant surprises.

    Just don't use Task Manager to monitor SQL's memory, it...

    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

    April 15, 2014 at 8:55 am

    #1706141

  • RE: Enabling LPIM and AWE

    sqlbuddy123 (4/15/2014)

    LPIM behaves differently on 32 bit and 64 bit systems and so is the AWE API. It's complex and lot of analysis is needed to get the true meaning....

    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

    April 15, 2014 at 8:51 am

    #1706138

  • RE: Enabling LPIM and AWE

    mlwiller2 (4/15/2014)

    4. On restart, enable (and check) AWE setting max system memory to?

    16 is probably a good place to start.

    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

    April 15, 2014 at 8:47 am

    #1706136

  • RE: Enabling LPIM and AWE

    mlwiller2 (4/15/2014)

    I'm still getting that error but when doing select @@version it says I'm at 0.0.5000 (sp4). Tried the exec xp_readerrorlog command and still didn't get the "locked memory 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

    April 15, 2014 at 8:34 am

    #1706126

  • RE: Does sql job skips the secdulted time , if job takes more time to finsh than the scheduled time.

    If you have a job scheduled for 2pm, 4pm and 6pm, the job starts at 2pm is still running at 4pm and finishes at 4:15pm, the job wills start again...

    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

    April 15, 2014 at 8:02 am

    #1706104

  • RE: Query optimization help

    ChrisM@Work (4/15/2014)

    Your query filters out a very small number of rows from the table - you may as well scan them all from an index ordered by , which should...

    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

    April 15, 2014 at 7:56 am

    #1706101

  • RE: Query optimization help

    Table definitions and index definitions 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

    April 15, 2014 at 4:52 am

    #1706031

  • RE: Query optimization help

    Table definitions, index definitions and execution plan please.

    How many rows qualify for that where clause predicate?

    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

    April 15, 2014 at 3:21 am

    #1706020

Viewing 15 posts - 9,286 through 9,300 (of 49,552 total)