Do you have another solution if you have application with two big tables both can benefit a lot from partitioning. We need 14 partitions for each plus regular 5 drives...

It's ok. I have separate partition function and schema for each table. My concern is that during switch affected disk (we defined separate for each file grup) have two partitions...

Nice article but I have two partition tables which share the same disks.

Thanks guys. I like this first option but I remember I played a little with this scenario 1-2 years ago and after alter database further restores were not possible. I...

We will keep OS on the same level: Windows 2003 SP2.

So it seems that replication is very good fallback option as I thought. Any cons?

Regarding query I have no particular one. I would like to know if there are some...

Of course testing is urgent but you can't check everything and it will be enough that there will be 1-2 such queries and you end in with 100 % of...

Finally it works. I used ap_addlinkedserver instead of sp_addserver. Strange thing that the last one works fione for default instance but doesn't for named. thanks for help.

Thanks a lot that's enough 🙂

HWID is quite big 886 927 rows. Subquery returns about 300-1000.

ALZDBA (2/28/2008)

---

in many cases the [not] exists with a correlated query will outperform a

left join with the where rightpart-table-column is null because

a [not] exists is performed using the...

I expect 8680. I've got 8623.

Regan Galbraith (2/28/2008)

how...

What's PSS?

CREATE TABLE REF_UPD_HWID (

[HWID1] [int],

[HWID2] [varchar] (50),

[status] [char] (1)

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[HWID](

[HWID1] [int] IDENTITY(10000,1) NOT NULL,

[HWID2] [varchar](50) NOT...

Sorry I made an mistake. This table is created in the first step of SSIS Package.

Then in second step I copy data from production to this table. And then runs...