Forum Replies Created

Viewing 15 posts - 16,396 through 16,410 (of 49,552 total)

  • RE: Data cache DMV

    Should be fine.

    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

    September 27, 2012 at 4:32 pm

    #1543150

  • RE: Doing simple count(*) how long is too long to get results

    Mark F-428640 (9/27/2012)

    INSERTINTO #CalendarKeys

    (

    CalendarDayKey

    ,CalendarWeekKey

    )

    SELECT DISTINCT

    CalendarDayKey

    ,CalendarWeekKey

    FROMdbo.DimCalendarDay dcd

    WHERELastProcessed = 1

    Does your calendar table have duplicate 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

    September 27, 2012 at 3:26 pm

    #1543129

  • RE: Data cache DMV

    sys.dm_os_buffer_descriptors

    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

    September 27, 2012 at 3:24 pm

    #1543127

  • RE: How to get LOCK information and resource name when running a query

    See my edit of the previous post.

    You're missing RID locks in your 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

    September 27, 2012 at 3:20 pm

    #1543124

  • RE: when store procedure recompiled last time

    SQL Trace or extended events (depending on version)

    btw, That's not actually a recompile. It's considered to be a compile because there's no matching plan in cache. Recompiles are only when...

    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

    September 27, 2012 at 1:57 pm

    #1543087

  • RE: How to get LOCK information and resource name when running a query

    No, it just means that there's a database-level lock. All sessions take a shared database lock, it's what prevents you from dropping an in-use database.

    Have you tried google? I'm sure...

    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

    September 27, 2012 at 1:51 pm

    #1543083

  • RE: Store error log entry that survives transaction rollback?

    Worth trying, just watch the locking on your logging table, don't want exclusive locks held 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

    September 27, 2012 at 1:17 pm

    #1543072

  • RE: How to get LOCK information and resource name when running a query

    sql-lover (9/27/2012)

    -Ability to see current type of lock: page, database, etc

    You already have that, it's the resource_type columns

    -Ability to see the specific locked resource's name (not id) . Example, 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

    September 27, 2012 at 1:07 pm

    #1543063

  • RE: Store error log entry that survives transaction rollback?

    Insert the data into a table variable, after the rollback insert that into a real table or whatever else you want to do with 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

    September 27, 2012 at 12:58 pm

    #1543061

  • RE: Supported for 2008 = will work on 2008 R2?

    Pretty much. There are maybe 3 smallish things that changed in the DB engine between 2008 and 2008 R2 and some bug fixes. Most of the R2 stuff was...

    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

    September 27, 2012 at 12:05 pm

    #1543039

  • RE: Size of a clustered index

    Yes

    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

    September 27, 2012 at 10:06 am

    #1542987

  • RE: Is ok to kill process with security id 0x01 ??

    Well, you can't kill a system process (and the old rule that spids < 50 are system is no longer true, there can be system spids with session IDs higher)

    KILL...

    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

    September 27, 2012 at 10:03 am

    #1542986

  • RE: SQL Server side trigger

    I suspect what you want here is a DDL trigger on create database, not a login 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

    September 27, 2012 at 9:43 am

    #1542977

  • RE: Size of a clustered index

    Close

    The non-leaf levels have just the key columns, leaf levels have all the columns in the 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

    September 27, 2012 at 9:39 am

    #1542974

  • RE: Size of a clustered index

    Bear in mind that the clustered index is the table and hence has all columns present at the leaf level.

    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

    September 27, 2012 at 9:10 am

    #1542963

Viewing 15 posts - 16,396 through 16,410 (of 49,552 total)