nice, thanks. being able to put a function in a check contraint is very useful...

decided to go with sparse vertical partitions.

updating pk/fk column of left tables to point to correct user stub table pk.

thanks anyway

this works but i dont like to use a loop and was hoping there might be some magic with a number table i could try....

declare @tab table...

Still no solutin to this....

Is my initial post not clear?

Has no one else tried to löog procedure calls from reporting services using SQL Server internals?

Perhaps i will have to write a clunky maual logging...

no one got any ideas then?

Sounds messy. Have you consdered bundling the parameters into a xml file and passing that?

I think this would be cleaner and woud avoid any limit/size problems.

http://www.sqlservercentral.com/Forums/Topic768454-338-1.aspx

Hi i am having a very similair problem which is not solved by any of the solutions in this thread. it is described in the link above.

All help...

that will tell me how much space is used 🙂 i want to know how much space is left is the space allocated to that database. thanks for your help.

Jules

Thanks for your replies.

i think i will write a little test and see how the heap with identiy performs against the CI with identity when under heavy inserts. I will...

Thanks to all who are helping me with this.

heres the table def

---------------------------

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Table_1](

[Col1] [int] IDENTITY(1,1) NOT NULL,

[col2] [int] NOT NULL,

[col3] [int] NOT NULL,

[col4] [int] NULL,

[col5]...

Hi would you mind expanding your post a little.

What are the disadvantages of having heaps.

And what size increase can iexpect from creating the clustered index.

Are inserts on heaps faster?

obviously the data in both the heap and the CI tables is the same.

they are used mainly for inserts.

are inserts into million row tables slower on heaps that tables with CI.

I can think of reasons for both answers.

How much space would...

And will enabling this PAE switch give make the memory availbel to Analysis services 2005. How do i enable this switch?

Thanks for your help