Viewing 15 posts - 16 through 30 (of 244 total)
nice, thanks. being able to put a function in a check contraint is very useful...
July 6, 2010 at 4:57 am
decided to go with sparse vertical partitions.
updating pk/fk column of left tables to point to correct user stub table pk.
thanks anyway
July 2, 2010 at 7:09 am
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...
March 20, 2010 at 11:44 am
Still no solutin to this....
December 3, 2009 at 1:56 am
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...
August 12, 2009 at 2:02 am
no one got any ideas then?
August 11, 2009 at 6:49 am
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.
August 11, 2009 at 4:19 am
http://qa.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...
August 11, 2009 at 3:47 am
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
July 21, 2009 at 8:14 am
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...
June 4, 2009 at 2:27 am
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]...
June 3, 2009 at 8:48 am
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?
June 3, 2009 at 7:49 am
obviously the data in both the heap and the CI tables is the same.
June 3, 2009 at 6:37 am
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...
June 3, 2009 at 5:46 am
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
May 29, 2009 at 1:29 am
Viewing 15 posts - 16 through 30 (of 244 total)