Viewing 15 posts - 3,286 through 3,300 (of 5,678 total)
Easiest way I know to do this is a dirty trick using FOR XML.
IF OBJECT_ID ( 'tempdb..#orders') is not null
drop table #orders
create table #orders(
oid int,
itemid int
)
insert into #orders (oid, itemid)
values...
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
April 29, 2011 at 3:48 pm
It's a common method to workaround dealing with bad design methods when inherited. I would recommend you do it in smaller chunks, however, working with the design teams towards...
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
April 29, 2011 at 3:20 pm
I've used temporary indexes both on temporary and permanent objects for a variety of reasons, but usually do to one off (like quarterly) processing that I don't want those 20-30...
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
April 29, 2011 at 2:41 pm
A bit of narcissism drove this, but I hit a whaaaaa type of site.
This site takes another site and completely frames it in its own advertising and stuff.
http://news.comrite.com/en/newsposts/39235
That points 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
April 28, 2011 at 6:16 pm
ZZartin (4/28/2011)
Have you tried using a derived column in the data flow to replace the columns you're getting bad data in with cleaned data?
While not a bad idea, the primary...
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
April 28, 2011 at 5:40 pm
Harry, go into the dataflow task and check what metadata type the column in question is. That will help us figure out where your issue might be hiding.
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
April 28, 2011 at 2:54 pm
Not sure if it would speed you up, but an inline script component checking the field as it passes by and using two output streams depending on results found would...
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
April 28, 2011 at 2:53 pm
Steve Jones - SSC Editor (4/28/2011)
I posted a note about understanding your access patterns for data, meaning hitting tables...
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
April 28, 2011 at 2:48 pm
Stefan Krzywicki (4/28/2011)
hillock666 (4/28/2011)
I'm wondering about marking a computed column as persisted is useful when I'm using a query fully covered with an index.
I think that this haven't...
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
April 28, 2011 at 2:43 pm
Thanks Igor, that'll help tremendously. There are a few ways to completely avoid aggregation methodology and using top 1 cross apply techniques as well... but they're uncommon, at best....
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
April 28, 2011 at 1:52 pm
Vedran Kesegic (4/27/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
April 28, 2011 at 1:44 pm
"You know Google? Okay, where you type in information, that's the front end. They make it pretty and give you a thousand options in a way you can...
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
April 28, 2011 at 1:02 pm
I can take a swing at this if Tom is feeling time pressured, I've pretty much avoided the entire debate out of self defense. Did you want these spackle-style...
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
April 28, 2011 at 12:48 pm
Igor check out the first link in my signature to show how to make your test data consumable.
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
April 27, 2011 at 12:33 pm
Heh, whoops, sorry, I didn't address one of your issues. Most likely the reason going to dirty reads got you out of this problem is that certain ID's probably...
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
April 27, 2011 at 11:15 am
Viewing 15 posts - 3,286 through 3,300 (of 5,678 total)