Forum Replies Created

Viewing 15 posts - 9,226 through 9,240 (of 49,552 total)

  • RE: Traces disappearing

    Unless you modified the script which profiler generated, it will have a file size of 5MB and no rollover set. That means as soon as the trace file reaches 5MB,...

    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 24, 2014 at 9:58 am

    #1708468

  • RE: Performance related question

    Table definitions, index definitions and execution plan 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 24, 2014 at 6:10 am

    #1708376

  • RE: Session hangs

    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

    April 23, 2014 at 1:40 pm

    #1708252

  • RE: Session hangs

    Restart SQL.

    There isn't a process at the OS level to kill (and if you have the idea of killing threads within SQL from the OS, that'll likely crash the SQL...

    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 23, 2014 at 11:23 am

    #1708205

  • RE: Are the posted questions getting worse?

    Steve, slight problem with the new forum name:

    It makes the prefix of the email subject way too long

    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 23, 2014 at 10:48 am

    #1708198

  • RE: How to Unlock the Database

    You need to grant the SQL Server service account (the account SQL runs under) full control of all data and log files and all folders which contain data and log...

    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 23, 2014 at 10:42 am

    #1708194

  • RE: How to Unlock the Database

    Still not understanding the problem, could you explain in more detail?

    If it's file permissions, then grant the needed permissions or ask your administrator to help 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

    April 23, 2014 at 8:44 am

    #1708143

  • RE: script to find most expensive queries across all databases

    That one will work. Just remove the reference to sys.procedures and instead cross apply to sys.dm_exec_sql_text for the procedure's definition.

    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 23, 2014 at 8:30 am

    #1708137

  • RE: How to Unlock the Database

    What do you mean 'unlock a database'? What are you trying to do?

    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 23, 2014 at 8:29 am

    #1708135

  • RE: Does the execution plan various version to version in sql server 2008

    No, the optimiser's the same in all the editions. Express won't run queries in parallel (it's limited to one CPU) for example, standard has memory limits, etc.

    The display of 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 23, 2014 at 7:52 am

    #1708105

  • RE: Open Source the MCM

    Brent Ozar (4/23/2014)

    A lot of the fun of the MCM lab was that the questions had surprising catches. The questions and answers alone weren't enough - the lab environment itself...

    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 23, 2014 at 7:04 am

    #1708075

  • RE: SQL Server 2008 R2 in hung state. Need help in analyzing the log.

    Perry Whittle (4/23/2014)

    in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B. Whenever 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 23, 2014 at 6:50 am

    #1708071

  • RE: Constraint Vs Trigger

    iam777here4u (4/23/2014)

    There are cases that business codes only contains two characters.

    Ok, but unless the *majority* of the values are two or one character, you won't be saving any space...

    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 23, 2014 at 3:49 am

    #1708014

  • RE: SQL Server Wait Time Clarification

    tfendt (4/22/2014)

    My understanding is the total time spent waiting is counted across all connections. So if I have 100 users and they all had to wait 1ms, sql server would...

    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 23, 2014 at 2:45 am

    #1707997

  • RE: Constraint Vs Trigger

    But you don't need to right trim everywhere, maybe on display but SQL ignores trailing spaces when doing comparisons.

    Yes, you can do validation in a trigger, but you're losing out...

    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 23, 2014 at 2:44 am

    #1707994

Viewing 15 posts - 9,226 through 9,240 (of 49,552 total)