Forum Replies Created

Viewing 15 posts - 12,646 through 12,660 (of 49,552 total)

  • RE: Automating the SQL Profiler

    You can't append a trace to an existing file. Change the script so that it always creates a different file. Having the datetime in the file name is usually 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

    June 20, 2013 at 3:48 am

    #1625785

  • RE: Find the correct answer in the following query

    aaron.reese (6/20/2013)

    Thanks for the explanation guys, I learned something today.

    Actually 2 things. 1) scope and 2) yet another reason not to use subqueries

    Correlated subqueries can be incredibly powerful, they're...

    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

    June 20, 2013 at 3:47 am

    #1625784

  • RE: Automating the SQL Profiler

    Fails with what error?

    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

    June 20, 2013 at 3:04 am

    #1625766

  • RE: Can mirroring be set up with a copy only backup?

    You don't need an off-schedule backup. Use your latest normal, scheduled backup and all log backups since that full backup.

    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

    June 20, 2013 at 3:04 am

    #1625765

  • RE: How to get user position in table i.e 1st 2nd, 3rd

    Ok, so the 1st user is the one who has the most rows with their name in the ReviewedBy, the 2nd user is the one with the second most 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

    June 20, 2013 at 3:03 am

    #1625764

  • RE: How to get user position in table i.e 1st 2nd, 3rd

    Position as determined by the data in what column?

    If a user is number 15, what column determines that? What column value determines if a user is before that or after...

    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

    June 20, 2013 at 2:45 am

    #1625756

  • RE: How to get user position in table i.e 1st 2nd, 3rd

    Position as per what column? What column in the table records that order?

    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

    June 20, 2013 at 2:15 am

    #1625743

  • RE: Dbcc checkdb command

    Repair is usually the last option for when there's no good backup.

    http://www.sqlservercentral.com/articles/Corruption/65804/

    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

    June 20, 2013 at 1:56 am

    #1625737

  • RE: 64-bit OS, 32-bit SQL Server 2000

    Please note: 5 year old thread.

    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

    June 20, 2013 at 1:11 am

    #1625727

  • RE: Non cluster index help (SSMS 2008 R2)

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    June 20, 2013 at 1:03 am

    #1625726

  • RE: Non cluster index help required (3 questions) : SSMS 2008R2

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1465465-392-1.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

    June 20, 2013 at 1:01 am

    #1625725

  • RE: Need to free up Physical memory (RAM)

    balasaukri (6/19/2013)

    I tried the techniques those are mentioned in the link already but nothing released the memory.

    Again, why are you trying to release memory? SQL needs that memory 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

    June 20, 2013 at 12:57 am

    #1625723

  • RE: having trouble granting role to user

    vxhughes (6/19/2013)

    Is there any way to tell (preferably via SQL commands, rather than via SQL Server management Studio, but either would be fine), which database my ROLE "testing" got associated...

    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

    June 19, 2013 at 4:10 pm

    #1625683

  • RE: how to manage memory for an sql server

    HildaJ (6/19/2013)

    but we still see high memory utilization on both sql server and os memory.

    Again, that is normal, expected behaviour.

    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

    June 19, 2013 at 3:55 pm

    #1625682

  • RE: Which one of the below operator takes the most time for execution?

    No way to answer that. Depends on too many factors including but not limited to row count and indexes.

    Question doesn't even make sense, IN and AND are not 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

    June 19, 2013 at 3:54 pm

    #1625681

Viewing 15 posts - 12,646 through 12,660 (of 49,552 total)