Estimating time for creation of clustered index

I asked my SQL Server to create me a clustered index on a 200,000ish
row table. It's taking rather longer than I expected. But, I don't
really know how long I should have expected it to take. How can I
estimate that?
Thanks!
IonDo you have a backup of the database? A pretty reliable way to see how this
will impact your production system is to restore it (on another server,
another instance, or on the same instance with a different database name),
and create the clustered index on the copy. It will be slightly affected by
factors such as different hardware and different activity, but unless the
situation is extreme, it should be within an order of magnitude.
I have not seen anything that resembles a formula for predicting how long a
clustered index will take, without doing any actual work. There are so many
variables involved, I think it will be every difficult to approach anything
even remotely trustworthy.
<ionFreeman@.gmail.com> wrote in message
news:1142528571.960565.264770@.j33g2000cwa.googlegroups.com...
>I asked my SQL Server to create me a clustered index on a 200,000ish
> row table. It's taking rather longer than I expected. But, I don't
> really know how long I should have expected it to take. How can I
> estimate that?
> Thanks!
> Ion
>

Error-the dimension is not referenced by a fact table?

Hi, all experts here,

Thank you very much for your kind attention.

I got a very strange problem during the creation of a cube.When I unchecked 'fact' for the dimension, It says-the dimension (in my case, the time dimension) is not referenced by a fact table. But actually in the data source view, I have already created relationships for the time diemnsion table and other fact tables? (in my case, due to the nature of the data, I set the fact tables also as dimensions). Why is that?

Hope my question is clear.

I am looking forward to hearing from you shortly and thanks a lot.

With best regards,

Yours sincerely,

Helen

Please help me to get a dimension as quarter, Year, Month using a column in a table

|||

Data source view (DSV) represents the relational source for the dimensions and measure groups. When you defined relationships between tables on DSV you helped the cube wizard to guess which tables should become source of dimensions and which should become the source of measure groups (later it is also used to create SQL queries during processing). It makes its guess, which might be not what you want. But the outcome of the wizard should be a cube, which can be built. Therefore when you unchecked the offered fact table the wizard shows you a message that it can't build a valid cube because in a valid cube a dimension must be related to at least one measure group. To complete the wizard you need to select another fact table, which you think should be correct source for the measure group.

You are not obligated to build the cubes with the wizard. To complete a wizard you need to select a fact table and then do what you think is right in the designer. There you would create your measure groups and relate them to the dimensions on Dimension Usage tab.

Hope my answer makes sense.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pip

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pip

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.