oli (8/10/2009)

---

Paul White (8/10/2009)

---

I deeply begrudge the minimum one star.

Gail's first post expresses it best, and in milder language terms than I might have used. I would encourage everyone...

Not having Standard Edition available I'd say to do some testing. It is possible that table partitioning created in Enterprise Edition my be supported in Standard Edition, just that...

GSquared (8/10/2009)

---

Lynn Pettis (8/8/2009)

---

sjsubscribe (8/7/2009)

---

GSquared, you still don't make sense. There is no place in our society for religious tests, no matter how well its masked. As the author asked...

Okay, I'm close. I think the difference I see in my nummay be due to rounding because of the small size of the decimal fields. The following code...

Gabriel P (8/9/2009)

---

Hello, I'm looking for a way to carry a continuous value across rows to calculate a weighted average.

create table t1

(

record_id int identity(1,1),

...

sjsubscribe (8/7/2009)

---

GSquared, you still don't make sense. There is no place in our society for religious tests, no matter how well its masked. As the author asked if it's baloney....

talltop (8/7/2009)

---

Whooaaa! really? Well maybe it is just me but if I had someone on my DBA maintenance team/rotation that did not know what the different db recovery models were...

talltop (8/7/2009)

---

Lynn Pettis (8/7/2009)

---

Hate to tell you, but discussion threads...

Hate to tell you, but discussion threads here on SSC...

thummalalavanya (8/7/2009)

---

Hi Friends,

I want to use Cte in my sql server 2005.What is Cte .why...

I will admit that I shrink the log file at times. Whenever I restore production to one of our training or development servers after changing the database to the...

Best thing you could do then is do the install for them. That way you know you are installing only the client tools.

What does the following query return?

select

mt1.AcctNo,

mt1.Mdate,

count(*) as RecCnt

from

dbo.MyTable01 mt1

inner join...

We now have a couple of dedicated servers for MOSS 2007. When I installed SQL Server on hose servers I used Latin1_General_CI_AS_KS_WS.

We also have a WSS setup on a...

hugh.hemington (8/6/2009)

---

So with four or more ways to do it, I found..... none of them! 🙂

Yeah, my head is still in row-wise manipulation but I'm trying. I've...