Forum Replies Created

Viewing 15 posts - 40,441 through 40,455 (of 49,552 total)

  • RE: Can we restrict windows authentication login to only selected databases..?

    swmsan (3/10/2009)

    How can I do the same with windows..?

    Exactly the same way you do with a SQL login.

    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

    March 10, 2009 at 9:19 am

    #956883

  • RE: Index Fragmentation/Identity Property

    Dave Mason (3/10/2009)

    I'm at a loss. How/why would the indexes become fragmented?

    Updates that increase the size of the row

    Database shrinks

    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

    March 10, 2009 at 9:15 am

    #956881

  • RE: Sql Server 2005 Error 109

    loki_l77 (3/10/2009)

    I also see that my sql server service is not running, do i need to have this service started before i login ?

    Um, yes. The service is 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

    March 10, 2009 at 9:05 am

    #956869

  • RE: Find out if the value in table was modified using SSMS.

    If you have an audit trigger, check the Application_name() function. If you're using a trace to audit, check the application_name column

    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

    March 10, 2009 at 9:04 am

    #956867

  • RE: Can we restrict windows authentication login to only selected databases..?

    Sure. Any login, windows or SQL will only have access to the databases it's granted access to. If you don't grant access to a database the person using the login...

    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

    March 10, 2009 at 9:03 am

    #956866

  • RE: Can I make this any faster

    chrisau168 (3/10/2009)

    Does that apply to me because in your post the NCI and CI must point to the same table with a nested join which does not seem to...

    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

    March 10, 2009 at 5:28 am

    #956683

  • RE: Can I make this any faster

    chrisau168 (3/10/2009)

    But I would like to know how did you know the 28% was a key look up. To be it said clustered index seek doesnt that mean 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

    March 10, 2009 at 5:00 am

    #956677

  • RE: Problem with Stored procedure

    DMVs don't store everything and they are not a replacement for SQL Trace.

    On a busy server use a server-side trace rather than the profiler GUI. The trace has minimal...

    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

    March 10, 2009 at 4:58 am

    #956676

  • RE: Problem with Stored procedure

    peace2007 (3/10/2009)

    The sqlserver is slow generally; everything with its database is slow

    Run profiler (or a server-side trace) for half an hour to an hour. Find the worst performing queries/procs...

    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

    March 10, 2009 at 2:24 am

    #956615

  • RE: The Rock and The Hard Place

    Spam. Reported to mod. No replies 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

    March 10, 2009 at 1:52 am

    #956603

  • RE: How to create trigger for all tables in database on insert, update table?

    thieuquanghuy (3/9/2009)

    I replace FOR LOGIN_EVENT with FOR LOGON, but I have an error:

    Msg 1084, Level 15, State 1, Procedure trg_LogonLog, Line 3

    'LOGON' is an invalid event type.

    I am very confused...

    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

    March 10, 2009 at 1:48 am

    #956602

  • RE: "Answered" Posts

    The ones in green are the flagged answers.

    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

    March 10, 2009 at 1:42 am

    #956600

  • RE: Are the posted questions getting worse?

    Kit G (3/9/2009)

    Lynn Pettis (3/9/2009)

    I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.

    Perhaps you should send back...

    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

    March 9, 2009 at 3:02 pm

    #956422

  • RE: Self blocking

    balbirsinghsodhi (3/9/2009)

    I am running this query on SQL2000 server.

    Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get...

    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

    March 9, 2009 at 2:35 pm

    #956411

  • RE: Are the posted questions getting worse?

    GSquared (3/9/2009)

    Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples....

    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

    March 9, 2009 at 2:35 pm

    #956408

Viewing 15 posts - 40,441 through 40,455 (of 49,552 total)