Viewing 15 posts - 2,776 through 2,790 (of 5,678 total)
We're definately going to need more information to help you puzzle this out.
can you provide the DDL to the table in question, and the actual execution plans? This isn'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
July 16, 2011 at 9:38 pm
whattheETL (7/15/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
July 15, 2011 at 4:34 pm
billiam904 (7/15/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
July 15, 2011 at 4:10 pm
billiam904 (7/15/2011)
At the moment, it is safer to stay at the job I am at. None of my old contacts are hiring either.
That's a decision you have to make....
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
July 15, 2011 at 3:14 pm
TravisDBA (7/15/2011)
Craig Farrell (7/15/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
July 15, 2011 at 3:07 pm
billiam904 (7/15/2011)
Craig,Are you will willing to work 12-15 hours a day
No.
for $600 a month?
If beers cost a buck at the bar and my rent was $150/month with $25/month in...
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
July 15, 2011 at 1:35 pm
Can you post the actual execution plans for us?
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
July 15, 2011 at 12:41 pm
Does anyone else see the problem with the concern of overseas outsourcing? It's not the people overseas that are the problem. We are.
We've fought long and hard 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
July 15, 2011 at 12:41 pm
Revenant (7/15/2011)
bopeavy (7/15/2011)
SQLRNNR (7-15-2011)
--------------------------------------------------------------------------------
motivation
observation
Conclusion
Wash, Rinse, and Repeat.
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
July 15, 2011 at 12:06 pm
To add to what Jason said, also see it from the business side.
When you call your cable company, which of the following do you want to hear?
"Yeah, Cable Internet, What's...
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
July 15, 2011 at 11:36 am
SevereIdea (7/15/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
July 15, 2011 at 11:32 am
graham.balmer (7/15/2011)
Ok. What about updating the partitioned view with another table, can't see how this can be done without referencing the view in the update to find the matching rows?
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
July 15, 2011 at 11:31 am
To redeem myself, with the A B only linked requirement, try the following:
SELECT
ms.*,
ma.*
from
#MySample AS ms
JOIN
#MyAddress AS ma
ONLEFT(ms.ID, 9) = RIGHT( ma.AddressCode, 9)
WHERE
LEFT( ma.Addresscode, 6) = 'A B '
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
July 15, 2011 at 11:21 am
Koen Verbeeck (7/14/2011)
Isn't this on the right track?http://www.microsoft.com/learning/en/us/course.aspx?id=2778A
It doesn't cover everything (such as reading a query plan), but it covers most of the basics...
Hm, right idea, but certainly misses a...
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
July 15, 2011 at 12:44 am
Unless the proc is performing dynamic sql, and if the proc is in the dbo schema, yes.
This is twofold. First, for the dynamic SQL, the dynamic component will then...
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
July 14, 2011 at 11:08 pm
Viewing 15 posts - 2,776 through 2,790 (of 5,678 total)