Viewing 15 posts - 151 through 165 (of 399 total)
I haven't read all of the replies to this article yet, but I appreciated it's detail to the RAID configurations, their penalties, and the calculation for the IOPS.
The only other...
May 1, 2012 at 11:42 am
No offense taken - I did look in BOL, but the examples I was looking for were specific to CREATE UNIQIUE CLUSTERED INDEX and primarily, just under the CREATE INDEX...
April 30, 2012 at 4:54 pm
GilaMonster (4/30/2012)
p.s. If you're partitioning on dates, partition RIGHT, not LEFT. Partitioning left with dates is horrid,...
April 30, 2012 at 4:36 pm
Hi Kraig! Yes - big ol db and partitioning for one table that has about 500 million rows in it. Here is a consolidated script, and my apologies...
April 30, 2012 at 4:34 pm
Is it because the columns for the table and index are using ID and the GPS_RECORD_DATE, and the function is only listing the date? If so - that is...
April 30, 2012 at 4:09 pm
GilaMonster (4/30/2012)
What's the partition function, what's the exact code you're running?
USE [V3_2]
GO
/****** Object: PartitionFunction [RecordsPartitionFunction] Script Date: 04/30/2012 14:23:56 ******/
CREATE PARTITION FUNCTION [RecordsPartitionFunction](datetime)
AS RANGE LEFT...
April 30, 2012 at 4:06 pm
Blah....
I get the following error (after having dropped and recreated the new PARTITION FUNCTION and PARTITION SCHEME)...
Msg 2726, Level 16, State 1, Line 2
Partition function 'RecordsPartitionFunction' uses 1 columns which...
April 30, 2012 at 3:21 pm
I am - quasi-DEV testing...Ish...It's a long story, but thank you so very much Gail. I will report my results back once this beast of a process finishes.
Rich
April 30, 2012 at 3:15 pm
GilaMonster (4/30/2012)
Rich Yarger (4/30/2012)
So - this will rebuild the Clustered Index / Primary Key be to a Unique Clustered Index / Primary Key?
Don't understand, A primary key is always enforced...
April 30, 2012 at 3:08 pm
Here is what I have successfully parsed...
CREATE UNIQUE CLUSTERED INDEX PK_BW_RECORD_EVENT_NEWFORMAT2
ON dbo.BW_RECORD_EVENT_NEWFORMAT2 (ID, GPS_RECORD_DATE)
WITH (DROP_EXISTING = ON) ON [RecordsPartitionScheme]
GO
So - this will rebuild the Clustered Index / Primary Key be...
April 30, 2012 at 2:57 pm
Nevermind - one clustered index per table only - back to basics. My bad Gail. Thanks again...
April 30, 2012 at 2:47 pm
Also - by making this a UNIQUE CLUSTERED INDEX, is this going to replace the PKey? Sorry for being so off-center here on this, but I am a little...
April 30, 2012 at 2:41 pm
Sorry - should have checked bol first, but when you say "whereever it's suppose to go" you mean the name of my Partition Scheme, and not a Filegroup - yes?
April 30, 2012 at 2:36 pm
Or I guess I am wondering if this is what I need...
CREATE PRIMARY KEY CLUSTERED INDEX 'PK_BW_RECORD_EVENT_NEWFORMAT2'
ON dbo.BW_RECORD_EVENT_NEWFORMAT2
WITH (DROP_EXISTING = ON); ON [RecordsPartitionScheme]
GO
April 30, 2012 at 2:31 pm
GilaMonster (4/30/2012)
Rich Yarger (4/30/2012)
April 30, 2012 at 2:24 pm
Viewing 15 posts - 151 through 165 (of 399 total)