Forum Replies Created

Viewing 15 posts - 601 through 615 (of 2,462 total)

  • RE: Growth in tempdb and more RAM

    From MSDN

    In a heavily loaded system under memory pressure, queries with merge join, sort and bitmap in the query plan can drop the bitmap when the queries do not get...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 1, 2013 at 11:56 pm

    #1572743

  • RE: Internal tables, inserted and deleted tables, change tracking

    SatishAyyar (1/1/2013)

    I am thinking they will be in TEMPDB

    i dont think , it should be in same database.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 1, 2013 at 11:40 pm

    #1572739

  • RE: Internal tables, inserted and deleted tables, change tracking

    Golfer22 (1/1/2013)

    I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?

    Do internal tables include inserted and deleted...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 1, 2013 at 11:39 pm

    #1572737

  • RE: Query for delete records between date range?

    opc.three (1/1/2013)

    With the query written this way I can highlight the SELECT statement in the USING clause to see what would be deleted without changing the query or carrying additional...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 1, 2013 at 11:12 pm

    #1572735

  • RE: Remove duplicate records?

    Duplicate post :alien: please post reply here http://www.sqlservercentral.com/Forums/Topic1401550-392-1.aspx

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    January 1, 2013 at 11:08 pm

    #1572734

  • RE: Updating an Entire Column in a 10 GB table

    chandan_jha18 (12/27/2012)

    in my update statement, the condition is such that the column may get changed from 1 to 2 and next time when update happens that set of data with...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 31, 2012 at 4:06 am

    #1572481

  • RE: New in this world.. no experience and no knowledge

    Koen Verbeeck (12/31/2012)

    If your boss wants you to learn SQL Server, he should provide you with the proper training. Or at least cover all your expenses.

    It should be but doesnt...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 31, 2012 at 3:50 am

    #1572479

  • RE: Record locking

    john 60195 (12/31/2012)

    One of the problems which I am trying to solve is once a user accesses (checks out) a secific record in a table, I would like all subsequent...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 31, 2012 at 3:04 am

    #1572465

  • RE: How to find column is having value or not

    Luis Cazares (12/28/2012)

    As others have said, neither CURSORS or WHILE LOOPS are effective. Here's a better solution that might help with this problem. I'm just publishing this to avoid that...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 31, 2012 at 12:42 am

    #1572436

  • RE: sprocs executed but rolled back? is there any log?

    sqldba_newbie (12/28/2012)

    I don't want to trace to run 24 X7 as i don't know when the issue would occur.

    thats why i asked you to use trace when ...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 30, 2012 at 11:58 pm

    #1572434

  • RE: Record locking

    YOu are basically asking about LOck mechanism. in your case when DML operation performs then exclusive locks are used by sql engine and it can get eslcalated from...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 30, 2012 at 10:12 pm

    #1572426

  • RE: Simple SQL Query

    burgergetsbored (12/30/2012)

    What I want to do is only return the visual that has the highest number next to it rather than all of them, am I able to do this...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 30, 2012 at 10:06 pm

    #1572424

  • RE: Database Monitoring tool

    you can think try this Quest : Spot light . its pretty handy. i have used this.

    see http://www.quest.com/spotlight-on-sql-server-enterprise/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 30, 2012 at 10:02 pm

    #1572423

  • RE: how to use all the pages of extent for the same table

    gkganeshbe (12/28/2012)

    It showed the pages count as 10. If we insert data for 8 pages it should use uniform extent. So only 2 extents should be used but it used...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 28, 2012 at 5:00 am

    #1572077

  • RE: How to get a row number which is failing during conversion

    Almost 3 years old thread

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

    December 28, 2012 at 4:28 am

    #1572072

Viewing 15 posts - 601 through 615 (of 2,462 total)