Forum Replies Created

Viewing 15 posts - 496 through 510 (of 758 total)

  • RE: Index Usage - Lookups

    GilaMonster (7/23/2012)

    Yes. Either a index seek + key lookup or a clustered index scan, depending on the % of rows that the query will retrieve

    Thanks

    I have created that table twice,...

    July 24, 2012 at 12:15 am

    #1516597

  • RE: Index Usage - Lookups

    GilaMonster (7/23/2012)

    SQLSACT (7/23/2012)

    I thought that a Lookup operation could only happen on a Heap Table where the NonClustered index has to do a RID lookup when the Index doesn't cover...

    July 23, 2012 at 8:34 am

    #1516273

  • RE: Index Usage - Lookups

    GilaMonster (7/23/2012)

    The clustered index doesn't do the lookups. It's the target of the lookups. That tells you how many lookups were done to the clustered index.

    Thanks

    I thought that a Lookup...

    July 23, 2012 at 8:16 am

    #1516252

  • RE: Performance Troubleshooting - Jonathan Kehayias and Ted Krueger Troubleshooting SQL Server

    😎

    Grant Fritchey (7/20/2012)

    SQLSACT (7/20/2012)

    Grant Fritchey (7/20/2012)

    The signal wait is just time waiting on the processor. It's an indication that for any given type of wait, you may, depending on what...

    July 20, 2012 at 5:28 am

    #1515450

  • RE: Performance Troubleshooting - Jonathan Kehayias and Ted Krueger Troubleshooting SQL Server

    Grant Fritchey (7/20/2012)

    The signal wait is just time waiting on the processor. It's an indication that for any given type of wait, you may, depending on what percentage the signal...

    July 20, 2012 at 5:09 am

    #1515433

  • RE: Alter Index Runtime

    SQLDBA360 (7/18/2012)

    Ah sorry yeah, didn't read your post correctly, thought the job had completed but had taken a long time. Using that DMV should help you locate what is...

    July 18, 2012 at 4:09 am

    #1514102

  • RE: Alter Index Runtime

    SQLDBA360 (7/18/2012)

    that DMV will only show current information, to capture blocking information the only thing I can think of is sp_blocker_ps008

    I understand that it only shows current information

    Will that DMV...

    July 18, 2012 at 4:01 am

    #1514100

  • RE: sys.dm_db_index_physical_stats - avg_page_space_used_in_percent

    Suresh B. (7/18/2012)

    BOL:

    NULL when mode = LIMITED.

    Thanks

    July 18, 2012 at 12:57 am

    #1514020

  • RE: xp_cmdshell

    OTF (7/17/2012)

    I would use a Powershell Script for this. Flexible and easy to change, if required.

    If you need help with it let us know.

    Thanks

    I definately need help with this

    Is...

    July 17, 2012 at 1:20 pm

    #1513834

  • RE: No Cursors.....

    Lynn Pettis (7/16/2012)

    SQLSACT (7/16/2012)

    Lynn Pettis (7/15/2012)

    The following code provides you with a cursor, while loop, and a set-based solution. Depending on the level of control you need will determine...

    July 16, 2012 at 8:59 am

    #1513136

  • RE: No Cursors.....

    Lynn Pettis (7/15/2012)

    The following code provides you with a cursor, while loop, and a set-based solution. Depending on the level of control you need will determine which you use.

    Also,...

    July 16, 2012 at 8:46 am

    #1513122

  • RE: No Cursors.....

    Lynn Pettis (7/14/2012)

    Not knowing what it is you are doing, using a cursor may be the correct thing to do. They do make sense for maintenance rountines and that...

    July 15, 2012 at 3:06 am

    #1512853

  • RE: No Cursors.....

    Reji PR (7/14/2012)

    Hi,

    why don't you use a while loop here?.

    select @maxrow = max(id) from #T

    SET @row = 1

    While (@row < @maxrow )

    Begin

    select x, y,......

    July 14, 2012 at 11:47 am

    #1512810

  • RE: No Cursors.....

    bitbucket-25253 (7/14/2012)

    One possible method is to use a temporary table for example:

    CREATE TABLE #T(Id INT IDENTITY(1,1),Tname VARCHAR(100),NumRows INT,RowsMod INT,Rspace INT, Uspace INT, StatDate DATETIME)

    INSERT INTO #T(Tname,NumRows,RowsMod,Rspace,Uspace,StatDate)

    SELECT --...

    July 14, 2012 at 8:51 am

    #1512798

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    GilaMonster (7/12/2012)

    Given it's name, what do you think? "waiting tasks"

    Also, what does Books Online say?

    Apologies

    I realised the mootness of the question the moment I hit "Post Quoted Reply"

    Thanks

    July 12, 2012 at 11:28 am

    #1512210

Viewing 15 posts - 496 through 510 (of 758 total)