Viewing 15 posts - 121 through 135 (of 240 total)
First, with the sample data you've provided, your UniqueID field isn't unique. So, I'm assuming we first remove those first 8 inserts.
Then, I'd use the Row_Number() function to assign priority...
May 26, 2011 at 9:48 am
Gianluca is right -- you'll have to use a substring function to extract the data. Using the tally table is blazing fast and elegant, but it may be overkill for...
May 24, 2011 at 10:32 am
Phil Parkin (5/12/2011)
Perhaps I should withdraw the post and take a few minutes...
May 12, 2011 at 10:07 am
Phil,
Yes, that would be a handy feature. But, then again, knowing how to grovel around in, and make sense of, the barely decipherable source code is why we get paid...
May 12, 2011 at 9:35 am
It could be further exaggerated I think if they were not declared as UNIQUE and there were duplicates in the data. Organizing the data on disk sequentially using an identity...
May 10, 2011 at 5:24 pm
To piggy back a little on what opc.three was saying...
You have relatively wide records with clustered indexes. If the order of the data in the clustering index fields is not...
May 10, 2011 at 4:14 pm
So, somebody asks us a question, we give them the right answer, then we find out we're wrong because they really meant to ask us a different question.
Sounds like what...
April 8, 2011 at 9:35 am
It sounds like what you're asking for is to return a string of a specified length given an input string of varying length.
When your input string is LONGER than...
April 7, 2011 at 10:04 am
Quite easily, actually.
Create a SSIS package. Add a data flow task.
Inside the data flow task, add a OLE DB source, utilizing a connection manager that points to the database where...
April 7, 2011 at 9:36 am
What results are you expecting to get?
It looks like your first output window is giving you what you are asking for -- did that come from your first query?...
January 27, 2011 at 12:56 pm
What? You're allowing a developer to touch production data? Yikes!
December 15, 2010 at 10:58 am
zintp (11/18/2010)
You may be interested in reading this article:
http://www.bidn.com/articles/integration-services/119/parallel-loads-in-ssis
which seems to be similar to Todd's idea, and additionally describes how to affinitize an SSIS process to a core,...
November 18, 2010 at 2:20 pm
John Rowan (11/18/2010)
Give me some time to get something written up. I can mock up an example on how this works including a view based interface into the...
November 18, 2010 at 1:47 pm
sqlrunner (11/18/2010)
November 18, 2010 at 12:15 pm
John Rowan (11/18/2010)
I'm sure there are more pros/cons that I listed here in a quick minutes, but that's the main area I can think of. Todd's method would work...
November 18, 2010 at 12:09 pm
Viewing 15 posts - 121 through 135 (of 240 total)