Fair enough.

Well, you're still going to have to wait till the full is done restoring before you can start applying logs, so even if you could restart the log backups...

Uh, why do you want to break the log chain?

There aren't really any good reasons to do so.

I would do this in a data flow instead of using control flow.

data source -> oledb command transform

Should take around 5 minutes to put together.

sliu (11/30/2011)

---

I have two tables:

create table #A(aYr int, aCol int)

insert #A(aYr,aCol) values (2008, 2)

insert #A(aYr,aCol) values (2009, 5)

insert #A(aYr,aCol) values (2010, 9)

insert #A(aYr,aCol) values (2011, 8)

create table #b(bYr int, bCol...

beejug1983 (11/30/2011)

---

Muthukkumaran,

This is not my home PC its client server, I have noticed one strange thing on sever also. Page Life Expectancy continuously remaining 1100+ I just could not understand....

they will be upgraded.

drew.georgopulos (11/30/2011)

---

i didnt post the example code because i am hoping the question doesnt demand it...

first piece neively works...am trying to get an amount of money specific to a year...

Post the actual (not estimated) execution plan for the query you want to optimize along with the table/index definitions for the referenced tables, and we'll be glad to walk you...

ankurk2 (11/30/2011)

---

I created stored proc so that user can select multiple comma separated values into single parameter.

Here I am getting some problem in looping those values. here is the code

Alter...

Swagger187 (11/30/2011)

---

Gianluca Sartori (11/25/2011)

---

Permissions don't "get lost", but may be revoked by something:

1) Explicit REVOKE commands

2) Drop / re-create view

Personally, I would investigate the drop/re-create as the most likely cause,...

using replication?

Here's how I would approach it if I had a large database and wanted to meet your requirements.

Instances:

TestServ1 -- infrastructure, not used by developers.

DevServ1, DevServ2, etc -- 1 instance per...

active or passive doesn't depend on number of nodes. It depends on the number of sql instances.

2 node cluster with 1 sql instance is active/passive.

2 node cluster with 2 sql...

rameshk_adusumilli (11/30/2011)

---

Hi All,

I've a query related to dynamic date and year :

select bug_id,

category,

count(*) Total_bugs,

SUM(CASE when bug_date >= '10/1/2011' and bug_date <= '10/31/2011' Then...

forsqlserver (11/29/2011)

---

2 node cluster is easy.

What to do either its a 3 node or 16 node cluster.What concept we should follow?

Actually I have to setup a 3 node cluster.

Is there...