Viewing 15 posts - 16 through 30 (of 156 total)
GilaMonster (9/26/2013)
September 27, 2013 at 11:52 am
GilaMonster (9/24/2013)
http://channel9.msdn.com/Events/Speakers/Mark-Russinovich The two Mysteries of Memory Management.
Super Useful. Thanks Gail.
September 25, 2013 at 9:37 am
Grant Fritchey (9/14/2013)
September 24, 2013 at 3:05 pm
GilaMonster (9/24/2013)
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...
September 24, 2013 at 2:48 pm
Jeff Moden (9/13/2013)
sunny.tjk (9/13/2013)
September 13, 2013 at 1:41 pm
Feeling stupid.
Thanks guys! Problem solved..
September 12, 2013 at 2:08 pm
Issue resolved.
I built a cursor to accomplish this. May not be the best choice but it worked for me.
Thanks guys.
August 21, 2013 at 2:52 pm
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...
August 20, 2013 at 5:22 pm
brad.corbin (6/5/2013)
To remove a column from replication...
June 5, 2013 at 8:08 pm
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...
June 5, 2013 at 9:31 am
Andrew Pruski (1/29/2013)
Would [WITH ROLLBACK IMMEDIATE] help?Andrew
Thanks Andrew. This worked. I'll read further on ROLLBACK IMMEDIATE.
January 29, 2013 at 1:02 pm
GilaMonster (1/11/2013)
For table ABC, probably. Not going to do much for the operations against XYZ of course.
Thank you, Gail.
January 11, 2013 at 10:37 am
GilaMonster (1/11/2013)
Given the predicates, switch the order of the key columns, it's not efficient for that query...
January 11, 2013 at 10:25 am
Grant Fritchey (1/9/2013)
January 9, 2013 at 7:50 am
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.
December 19, 2012 at 11:15 am
Viewing 15 posts - 16 through 30 (of 156 total)