Forum Replies Created

Viewing 15 posts - 14,176 through 14,190 (of 19,562 total)

  • RE: How to tell the difference between live installations and MSDN installations

    I can't find the document, but I have been told that when purchasing volume license agreement and MSDN.

    If in doubt ask the licensing partner.

  • RE: How to tell the difference between live installations and MSDN installations

    You need to know what servers are "Production"

    Non production development servers don't need to be licensed. Thus knowing what servers are serving up production data and apps will help...

  • RE: help with this query

    I would recommend not to use sys.sysindexes since it is a soon to be deprecated view. It will work currently but may not be in the next release of...

  • RE: SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file

    NJ-DBA (5/6/2010)


    I will bet $$ that this server is running diskkeeper.

    It's also possible that there is some other form of disk defragmenter on the system that runs a scheduled defrag.

  • RE: Today's Random Word!

    Trey Staker (5/6/2010)


    Trey Staker (5/6/2010)


    CirquedeSQLeil (5/6/2010)


    Lynn Pettis (5/6/2010)


    Actually, the problem is I'll need a vacation from the vacation. A week from Sunday will be 14+ hours of driving (coming...

  • RE: Are the posted questions getting worse?

    Paul White NZ (5/6/2010)


    Grant Fritchey (5/6/2010)


    And by the way, just passed 8000 points. #10 to do so.

    Now I'll let Jason & Paul pass me.

    Jason's gone through. I'm more...

  • RE: Training for Managers

    Lynn Pettis (5/6/2010)


    Trick is getting some of them to buy in. Sys Admins? Good luck, we can't even get them to tell us why our servers crashed, or...

  • RE: Today's Random Word!

    Lynn Pettis (5/6/2010)


    CirquedeSQLeil (5/6/2010)


    Lynn Pettis (5/6/2010)


    crookj (5/6/2010)


    sing4you (5/6/2010)


    crookj (5/6/2010)


    CirquedeSQLeil (5/6/2010)


    bcsims 90437 (5/6/2010)


    El Paso? Salsa... it's almost lunchtime.

    Jalapenos

    Chili Cookoff (New Mexico or Arizona style!)

    Joe

    Don't forget Texas. ...

  • RE: Clustered indexes

    Of 928 respondents only 21 have answered it correctly. A whopping 2% correct.

  • RE: Today's Random Word!

    Lynn Pettis (5/6/2010)


    crookj (5/6/2010)


    sing4you (5/6/2010)


    crookj (5/6/2010)


    CirquedeSQLeil (5/6/2010)


    bcsims 90437 (5/6/2010)


    El Paso? Salsa... it's almost lunchtime.

    Jalapenos

    Chili Cookoff (New Mexico or Arizona style!)

    Joe

    Don't forget Texas. It may be...

  • RE: Current queries running on Tempdb

    rambilla4 (5/6/2010)


    I ran the same query 'query2' again. But I did not get any high values for internal_objects_alloc_page_count from spot light session.

    SELECT top 5 *

    FROM sys.dm_db_session_space_usage

    ORDER BY...

  • RE: Current queries running on Tempdb

    MANU-J. (5/6/2010)


    Query 2 output for spotlight process(Session_id 118 is Spot light monitoring tool user connected to QuestWorkDatabase) as per internal_objects_alloac_page_count is 606664 pages i.e. 4.63gb.

    That is the one I...

  • RE: Training for Managers

    The second part of Lynn's question - what to present on in lunch n learns.

    Anything you want that you have been working on.

    Best practices

    Indexes

    Mirroring

    Disk setup for optimal DB performance

    Performance tuning

    Execution...

  • RE: Training for Managers

    Lynn Pettis (5/6/2010)


    CirquedeSQLeil (5/6/2010)


    Lynn Pettis (5/6/2010)


    Jeff Moden (5/5/2010)


    Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful...

  • RE: Calculating cumulative product from previous row (without using cursors)

    Here is the update then:

    DECLARE @Scores TABLE

    (

    ID INT,

    ...

Viewing 15 posts - 14,176 through 14,190 (of 19,562 total)