Viewing 15 posts - 1 through 15 (of 48 total)
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
May 29, 2009 at 6:54 am
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
May 29, 2009 at 6:44 am
Nice article but I have two partition tables which share the same disks.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
May 29, 2009 at 6:19 am
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
May 21, 2008 at 1:26 am
We will keep OS on the same level: Windows 2003 SP2.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
May 6, 2008 at 9:15 am
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
April 16, 2008 at 1:16 am
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
April 15, 2008 at 8:03 am
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.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
April 7, 2008 at 12:53 am
Thanks a lot that's enough 🙂
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
March 5, 2008 at 12:45 am
HWID is quite big 886 927 rows. Subquery returns about 300-1000.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
March 4, 2008 at 12:57 am
ALZDBA (2/28/2008)
left join with the where rightpart-table-column is null because
a [not] exists is performed using the...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
March 3, 2008 at 10:40 am
Regan Galbraith (2/28/2008)
how many rows do you expect to process? Is 8000 all the data, or is that perhaps just 1 buffer?
I expect 8680. I've got 8623.
Regan Galbraith (2/28/2008)
how...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
March 3, 2008 at 7:56 am
What's PSS?
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 27, 2008 at 4:05 am
ALZDBA (2/26/2008)
- Can you post the ddl (sql2000 and sql2005) ? (tables/indexes/views)
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 26, 2008 at 6:56 am
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...
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
February 26, 2008 at 4:42 am
Viewing 15 posts - 1 through 15 (of 48 total)