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...

Super Useful. Thanks Gail.

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...

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...

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,...

Feeling stupid.

Thanks guys! Problem solved..

Issue resolved.

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

Thanks guys.

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...

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...

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...

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

Thank you, Gail.

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...

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...

Yeah, I think this is the only option left.

Thanks everyone.