Forum Replies Created

Viewing 15 posts - 22,576 through 22,590 (of 49,552 total)

  • RE: PF usage Problem

    MasterDB (11/2/2011)

    I ran perfmon , in that am not able to find the paging in the .csv file.

    please can u explain how to check the paging through perfmon.

    Paging file %...

    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 2, 2011 at 1:01 am

    #1401986

  • RE: How to find out indexes/constraints physical location ?

    Primary key and unique constraints are enforced by indexes, so, exactly the same as normal indexes.

    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 1, 2011 at 4:06 pm

    #1401911

  • RE: Protecting Intellectual Property - execute access only to SP

    PhilM99 (11/1/2011)

    So I conclude that giving a user Execute permissions does not allow them the right to view the stored proc.

    I'm sure I've seen execute permissions letting the user...

    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 1, 2011 at 3:08 pm

    #1401891

  • RE: How to find out indexes/constraints physical location ?

    jared-709193 (11/1/2011)

    I think the idea is that SQL Server defines the index's storage by FILEGROUP, therefore making it impossible to determine how much of the index resides on either physical...

    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 1, 2011 at 2:55 pm

    #1401882

  • RE: How to find out indexes/constraints physical location ?

    They'll be in both. If there are multiple files in a filegroup, SQL spreads data across all of them.

    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 1, 2011 at 1:58 pm

    #1401833

  • RE: Identifying who took a database offline

    Revenant (11/1/2011)

    jared-709193 (11/1/2011)

    . . . Isn't it interesting how Microsoft developers can't design an application that effectively uses their own database engine? I would even accept one that followed at...

    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 1, 2011 at 1:56 pm

    #1401831

  • RE: conversion deadlock - how to address?

    The .Net data access defaults to serialisable, that's probably why the isolation level is so high. If the isolation level was SQL's default (read committed) then likely this deadlock wouldn'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

    November 1, 2011 at 10:05 am

    #1401723

  • RE: What is kept in transaction log and what is not?

    Do you know when the data was modified?

    A log reader might give you what was done (if it happened during the time you have log backups over), but it won'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

    November 1, 2011 at 10:03 am

    #1401721

  • RE: What is kept in transaction log and what is not?

    Aivars Herings (11/1/2011)

    How to say ... currently I am trying to understand who or what has modified data in one of databases I am responsible for.

    Since this has happened...

    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 1, 2011 at 9:39 am

    #1401706

  • RE: index on big table

    Eric M Russell (11/1/2011)

    If the clustered index is on a non-unique key, then SQL Server will still use the default 8 byte rowid.

    The 8-byte RID is only used in nonclustered...

    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 1, 2011 at 9:37 am

    #1401705

  • RE: Blocking

    venoym (11/1/2011)

    1. How does a simple stored procedure that does a single SELECT (returning no more than 500 rows in about 3000 reads and 100 ms) get into the SUSPENDED...

    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 1, 2011 at 9:29 am

    #1401701

  • RE: What is kept in transaction log and what is not?

    First, 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

    November 1, 2011 at 9:27 am

    #1401698

  • RE: What next after the wait types are gathered

    Here's the whitepaper on the waits and queues tuning methodology:

    http://sqlcat.com/sqlcat/b/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx

    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 1, 2011 at 8:49 am

    #1401670

  • RE: What is kept in transaction log and what is not?

    Aivars Herings (11/1/2011)

    Hello all,

    Does transaction log stores some information about transactions that has been actually rolled back by server?

    Yes. Every single modification made to the database is logged...

    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 1, 2011 at 8:28 am

    #1401661

  • RE: Protecting Intellectual Property - execute access only to SP

    It's a tad more complex. As soon as they have execute rights on the procedure they'll automatically have rights to view the procedure's definition. You can do things like impersonation,...

    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 1, 2011 at 8:25 am

    #1401659

Viewing 15 posts - 22,576 through 22,590 (of 49,552 total)