Viewing 15 posts - 781 through 795 (of 5,678 total)
Most likely they're validating. Turn on Delay Validation.
Also, make sure you're using what's become a defacto standard for SSIS called procs:
SET NOCOUNT ON;
SET FMTONLY OFF;
WHILE 1=0
BEGIN
-- Result set for...
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
March 13, 2013 at 12:53 pm
I've been consulting for years, and every now and then this lovely little item pops up.
I ignore the 30 minute calls on the weekend if I don't have to login...
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
March 12, 2013 at 5:35 pm
Merge is, generally, better than hash.
That said...
You mentioned you created new statistics, but did you update with fullscan? On BOTH systems? I'm wondering if the Test system is...
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
March 12, 2013 at 5:31 pm
PIVOT
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
March 12, 2013 at 5:29 pm
Not sure if you're still on this thread, Tavis, but that's a neat trick. May require some on the fly trickery to my base data to NULL, child 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
March 12, 2013 at 4:58 pm
Like will perform more optimally when used like a LEFT(). Otherwise they're both going to scan. LIKE I believe has a better chance of using Full Text Indexing...
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
March 8, 2013 at 3:19 pm
RP_DBA (3/8/2013)
The discussion I was involved in didn't key on messy, poorly performing code but rather on routinely taking shortcuts and not following best practices.
Depends on the best practice....
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
March 8, 2013 at 3:16 pm
For SSIS, there's a few things I recommend. Most of them revolve around Configurations.
I know why standards exist and mostly that's to keep some nut with his own idea...
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
March 8, 2013 at 12:35 pm
As usual, it depends.
Replication uses locking like anything else. Even if you have a row filter on, unless that's a VERY small row filter (5000 rows or less), 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
March 8, 2013 at 12:27 pm
I would say no. Random code samples are a poor method, simply because a lot of what we do *is* simple and doesn't need a lot of exposition or intricate...
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
March 8, 2013 at 12:24 pm
This is an article of mine, but it may help you a bit:
http://www.sqlservercentral.com/articles/Career/71608/
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
March 6, 2013 at 4:27 pm
Offhand, I have no idea and you're dealing with some really idiosyncratic glitch. I'm relatively sure you won't know for sure unless you call Microsoft and they look into...
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
March 6, 2013 at 12:32 pm
Tavis,
That looks awesome, and similar to where I was probably going to end up with self-referencing proc calls but this looks a lot cleaner.
Thank you for this. Once I...
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
March 6, 2013 at 12:27 pm
Ugh, not a fun process, particularly when row order matters. Don't feel bad about struggling with it, it's neither obvious nor simple.
Basically you're looking for the quirky update or...
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
March 5, 2013 at 4:50 pm
J,
A few things.
One, your code seems incomplete. There's BEGINs without ENDs, and there's no real reason to have them there.
Next, your query plan is incomplete. 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
March 4, 2013 at 5:42 pm
Viewing 15 posts - 781 through 795 (of 5,678 total)