ihsanps (3/21/2010)

---

HI,

Below are the Process which i m doing inside the cursor.Hope this will help you to give me a better solution.

OPEN @getData

FETCH NEXT FROM @getData INTO @DateValue,@Value

WHILE @@FETCH_STATUS =...

TRACEY-320982 (3/21/2010)

---

Right now I have the following

There are approx 133095 rows per day.

DELETE TOP(100000)

FROM tablename WHERE

startdate >= '2009-12-17' and

startdate <= '2009-12-17'

Then this uses approx 10 GIG of Log...

Dang it - you are quite right. Per socket is what I thought I wrote...thanks.

If it is already installed and you are upgrading - upgrade everything that is installed. If you are not using SSIS, you could uninstall it, but at this point...

pshaship (3/20/2010)

---

I'm NOT seeing these warning messages when I restart the nodes in below order:

Restart Node1 (Active)

Restart Node2 (Active)

Restart Node3 (Passive)

If I did not follow the above order to restart...

Ser Tharg (3/19/2010)

---

I need some clarity on Licencing on the CPU side:

- Dual/Quad core: this only counts as one...is this correct?

- If you have 2 SQL servers on one physical...

pshaship (3/19/2010)

---

Thanks Steve,

We are using maintenance plans for Maintenance tasks, so we need SSIS

and we do not need SSRS & SSAS and I already skipped those. But my question is...

That looks correct to me. Any services that are managed by the cluster need to be set to manual.

BTW - did you get your SAN issues squared away? ...

Yes - but that is what would be so much fun 😀

Hold on - you don't need an NLB cluster for this. Enterprise Edition allows for scale-out reporting services installation.

What you do is install reporting services on each node in...

GSquared (3/18/2010)

---

john.arnott (3/18/2010)

---

Sometimes I think about teasing my DBA by saying stuff like "since clustered indexes are better than non-clustered, ...

So, one of your customers upgraded to SQL Server 2008...

I have to ask why this requirement to downgrade the system? Is this for a customer that has not upgraded yet or is there some other reason why you...

And there you go - that is exactly why we call this a community...

sqlolmy (3/16/2010)

---

We need to use SQL BIDS 2005 to access a SQL 2008 Database -Can this be done? After we create a new Project and datasource in BIDS 2005...