Viewing 15 posts - 4,261 through 4,275 (of 5,678 total)
kellerb (1/24/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 8:50 pm
See how this works for you:
Sample Data:
IF OBJECT_ID( 'DeFielder') IS NOT NULL
DROP TABLE DeFielder
CREATE TABLE DeFielder
(RowID INT IDENTITY( 1, 1),
FileTypeID INT,
FileData VARCHAR(MAX)
)
ON [PRIMARY]
GO
INSERT INTO DeFielder( FileTypeID, FileData)
SELECT1, '1,2,3,4,5,"abc,def",6,7,"yui,asd"' UNION ALL
SELECT1,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 8:27 pm
Can you screen shot the next two windows as well (Parameters and result set)? Or if you can simply confirm they're empty, that would help.
Next troubleshoot would be to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 7:41 pm
I wouldn't argue that there's some options available to build some nice front ends for Full Text Indexing.
I would argue these points:
1) We do database here, not front ends. ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 7:39 pm
Short answer: You can't. SSIS doesn't allow for dynamic metadata (schema) at runtime.
Longer answer: There are workarounds. Massive Script enable/disable structures on a file by file basis...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 7:35 pm
*fwip*fwip*fwip*fwip*fwip*CRASH*
Quoth the Craig: Ow...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 5:21 pm
Grant Fritchey (1/24/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 5:05 pm
Don't use replace column in the lookup, create a new one and use Role2 throughout the rest of the script, just carry Role around with it, unused.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 5:02 pm
Incredibly helpful. It tells us that you have user contextual logic changes that may be occurring.
Here's your next step: Dig down to the deepest call. Find out if...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 4:57 pm
It shouldn't, so that's confusing. Can you describe more about how you're making the calls? Are you opening up a query window connected to the server with the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 4:06 pm
Is google hiring or is this a source forge project?
That's a lot of work and technique that would either need to become opensource, or it's going to end up as...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 3:44 pm
Hmmm, interesting puzzle.
Ferguson (1/18/2011)
Did...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 1:53 pm
Just to wrap my head around the issue, are we discussing this 2TB issue:
http://blogs.technet.com/b/askcore/archive/2010/02/18/understanding-the-2-tb-limit-in-windows-storage.aspx, which is storage related...
or this one:
Which is RAM/Memory related?
Most significantly, Microsoft has added a Datacenter edition...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 1:16 pm
These aren't Oracle script errors, but SSIS object errors.
My first thought is to turn BypassPrepare to TRUE.
After that, we'd have to evaluate the properties and settings in the object.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 1:06 pm
Oh, I agree from a security perspective it's a bit twitchy, but I was looking at it from a maintenance point of view.
Having to rebuild operators for new/old users receiving...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 11:27 am
Viewing 15 posts - 4,261 through 4,275 (of 5,678 total)