Viewing 15 posts - 121 through 135 (of 211 total)
On the ordering of rows and 1NF...
Is the disconnect here not between the idea of rows which are ordered when used, and rows which are inherently ordered? If I have...
October 13, 2011 at 2:56 pm
The configurationfilter column would specify which packages use which rows.
Since the configurationfilter column cannot contain two values, each package needs its own row for server2.
I know that one solution people...
October 11, 2011 at 11:29 pm
I'm not overly fussed with "strict" adherence to 3NF. First of all, I'm more of a BCNF man myself. Secondly, this design in SSIS is still a form of OTLT...
October 11, 2011 at 4:47 pm
Thanks, I expect this trend of everyone wanting roles to reflect permissions and not people (as is my preference as well) is going to continue. I was curious because I...
October 11, 2011 at 2:35 am
Thanks for your response, but I'm still not quite clear on your method.
If you had a role called "db_developer" which gave high privileges in the dev environment, would you create...
October 11, 2011 at 1:54 am
Data driven SSIS: yes, I did suggest this as a consideration (I'm not the one actually developing or driving the development of the tool). I think the difficulty with that...
July 29, 2011 at 9:36 pm
It sounds like the result of this query will be used quite heavily since all the legacy code will depend on the joined output.
It's quite common to index your...
July 27, 2011 at 10:48 pm
Some of my thoughts on this topic here: http://www.sqlservercentral.com/blogs/don_halloran/archive/2010/12/12/sql-standards.aspx
July 27, 2011 at 8:23 pm
I suppose so, I guess it depends on how long the process has been running for. If you've already got, say, 365 days worth of data, I wouldn't think a...
June 17, 2011 at 12:03 pm
My mind first jumped to indexing but I don't think it makes sense. Why would a reboot fix it? There's no indication in the OP that a truncate-reload is happening...
June 17, 2011 at 12:33 am
Do you have an opportunity to watch (or record) activity from sp_who2 (or Adam Machanic's sp_whoisactive, great demo here)? Check the wait types.
It's an interesting problem given the fact that...
June 16, 2011 at 4:29 pm
There are two ways to do this (three, but I don't think one counts).
One is to have a complete table for each entity describing all attributes. In your case, UserTypeA...
June 16, 2011 at 1:00 pm
Could you please elaborate on that a little more where you could introduce physical fragmentation here.
Just as you said, it's going to happen if you're releasing free space and especially...
June 15, 2011 at 5:12 am
Jeff Moden (6/14/2011)
It's also going to have to be dynamic (I believe) which is going to make it even uglier and slower.
I think the idea would be a huge if...
June 14, 2011 at 11:27 pm
Craig Farrell (6/14/2011)
Some Bit vs. Bitmap testing.
That was unexpected. Thanks for posting this.
June 14, 2011 at 10:24 pm
Viewing 15 posts - 121 through 135 (of 211 total)