Forum Replies Created

Viewing 15 posts - 16 through 30 (of 156 total)

  • RE: Memory assigned to the OS

    GilaMonster (9/26/2013)


    There's no memory 'assigned' to the OS. 8GB is what SQL is leaving for the OS and any other app running on that server. That's rather a high figure...

  • RE: Virtual memory

    GilaMonster (9/24/2013)


    http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.

    Super Useful. Thanks Gail.

  • RE: MAXDOP question

    Grant Fritchey (9/14/2013)


    I would not recommend disabling parallelism. It's a good thing. I would suggest that you bump up the default value for the cost threshold for parallelism. The default...

  • RE: Virtual memory

    GilaMonster (9/24/2013)


    No.

    Virtual address space is 2GB on 32 bit, many hundreds of TB on 64 bit. Commitable virtual memory is physical memory + page file size.

    It's complex, there's a couple...

  • RE: MAXDOP question

    Jeff Moden (9/13/2013)


    sunny.tjk (9/13/2013)


    The computer that i run queries on has 2 processors. Shouldn't query1 execute faster than query2 ? Surprisingly, both executed taking exact time. Also, on OLTP system,...

  • RE: Transaction Isolation question

    Feeling stupid.

    Thanks guys! Problem solved..

  • RE: Datatype conversion

    Issue resolved.

    I built a cursor to accomplish this. May not be the best choice but it worked for me.

    Thanks guys.

  • RE: Datatype conversion

    Right now, the numeric values in that column are like (345.678987689). I'd like to change these values to 3 decimal places. For example(345.678).

    Since this column also has non-numeric values, the...

  • RE: Remove a column in an article from Replication without reinitializing the replication

    brad.corbin (6/5/2013)


    This is an older question, but I wanted to add a reply, I don't think the above answers are what you are looking for.

    To remove a column from replication...

  • RE: Transactional replication question

    Sorry guys.

    I think I was too quick to post this but just read on BOL that ALTER TABLE..DROP COLUMN command is always replicated to its subscribers even if the we...

  • RE: Changing database to Read_Write

    Andrew Pruski (1/29/2013)


    Would [WITH ROLLBACK IMMEDIATE] help?

    Andrew

    Thanks Andrew. This worked. I'll read further on ROLLBACK IMMEDIATE.

  • RE: Question on Index with Included columns

    GilaMonster (1/11/2013)


    For table ABC, probably. Not going to do much for the operations against XYZ of course.

    Thank you, Gail.

  • RE: Question on Index with Included columns

    GilaMonster (1/11/2013)


    You can't have a column in the key and include. One or the other.

    Given the predicates, switch the order of the key columns, it's not efficient for that query...

  • RE: Data distribution

    Grant Fritchey (1/9/2013)


    If the column has statistics on it, those represent the data distribution as SQL Server understands it. You can use DBCC SHOW_STATISTICS to see the density, also known...

  • RE: Rowcount of the biggest table

    Richard Fryar (12/19/2012)


    That can happen in SQL Server 2000.

    Have you tried running DBCC UPDATEUSAGE?

    Yeah, I think this is the only option left.

    Thanks everyone.

Viewing 15 posts - 16 through 30 (of 156 total)