Click here to Skip to main content
15,899,126 members
Home / Discussions / Database
   

Database

 
QuestionOpenRowSet - Sql server Pin
Hum Dum20-May-11 19:58
Hum Dum20-May-11 19:58 
AnswerRe: OpenRowSet - Sql server Pin
Shameel25-May-11 8:14
professionalShameel25-May-11 8:14 
QuestionSQL Mystery Pin
Super Lloyd20-May-11 4:46
Super Lloyd20-May-11 4:46 
AnswerRe: SQL Mystery Pin
Chris Meech20-May-11 7:48
Chris Meech20-May-11 7:48 
QuestionSQL Stored Procedure Question??? Pin
Toniyo Jackson19-May-11 21:47
Toniyo Jackson19-May-11 21:47 
AnswerRe: SQL Stored Procedure Question??? Pin
dasblinkenlight20-May-11 0:59
dasblinkenlight20-May-11 0:59 
AnswerRe: SQL Stored Procedure Question??? Pin
David Skelly20-May-11 1:50
David Skelly20-May-11 1:50 
QuestionOracle partitioned indexes... Pin
Paladin200019-May-11 2:51
Paladin200019-May-11 2:51 
I thought that I understood them, but they aren't working as I expected. Perhaps someone can help dispel my confusion?

I have a table that is comprised of an incrememnting, numeric primary key, a date field, and several other fields (that are irrelevant to the problem). It is range partitioned by day on the date field, thus creating a new table partition for every 24 hours of data.

The problem comes when I need to drop an old partition. I created the PK index as LOCAL, which (as I understood from the documentation) should have made it equipartition with the table. However, when the old partition(s) are dropped, it becomes unusable, and rebuilding the index can take hours (it is a VLDB).

Any ideas what I am doing wrong..? Thank you.
AnswerRe: Oracle partitioned indexes... Pin
Paladin200019-May-11 4:11
Paladin200019-May-11 4:11 
Questionimage databasee Pin
mrjaya18-May-11 19:17
mrjaya18-May-11 19:17 
AnswerRe: image databasee Pin
Mycroft Holmes18-May-11 19:35
professionalMycroft Holmes18-May-11 19:35 
Questionstring concadination in sql query Pin
yesu prakash17-May-11 20:39
yesu prakash17-May-11 20:39 
AnswerRe: string concadination in sql query [modified] Pin
Blue_Boy17-May-11 21:02
Blue_Boy17-May-11 21:02 
AnswerRe: string concadination in sql query Pin
Pete O'Hanlon17-May-11 21:03
mvePete O'Hanlon17-May-11 21:03 
AnswerRe: string concadination in sql query Pin
Ra-one17-May-11 21:04
Ra-one17-May-11 21:04 
AnswerRe: string concadination in sql query Pin
Shameel18-May-11 0:43
professionalShameel18-May-11 0:43 
QuestionSQL Server. Insert into table whiles querying Pin
Eli Nurman16-May-11 19:05
Eli Nurman16-May-11 19:05 
AnswerRe: SQL Server. Insert into table whiles querying Pin
Gerben Jongerius16-May-11 20:05
Gerben Jongerius16-May-11 20:05 
GeneralRe: SQL Server. Insert into table whiles querying Pin
Eli Nurman17-May-11 0:21
Eli Nurman17-May-11 0:21 
GeneralRe: SQL Server. Insert into table whiles querying Pin
Gerben Jongerius17-May-11 3:22
Gerben Jongerius17-May-11 3:22 
AnswerRe: SQL Server. Insert into table whiles querying Pin
Luc Pattyn16-May-11 22:59
sitebuilderLuc Pattyn16-May-11 22:59 
GeneralRe: SQL Server. Insert into table whiles querying Pin
Eli Nurman17-May-11 0:23
Eli Nurman17-May-11 0:23 
AnswerRe: SQL Server. Insert into table whiles querying Pin
Luc Pattyn17-May-11 0:30
sitebuilderLuc Pattyn17-May-11 0:30 
AnswerRe: SQL Server. Insert into table whiles querying Pin
PIEBALDconsult17-May-11 2:57
mvePIEBALDconsult17-May-11 2:57 
GeneralRe: SQL Server. Insert into table whiles querying Pin
David Mujica17-May-11 9:04
David Mujica17-May-11 9:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.