Viewing 15 posts - 4,006 through 4,020 (of 5,678 total)
Hey Lutz and Magoo?
I'll admit my XQuery is very weak. One of the things that's always confused me is this part:
FROM
@XML.nodes ('/ROOT/Customer') as cust(cn)
cross apply
...
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
February 15, 2011 at 4:51 pm
LutzM (2/15/2011)
GilaMonster (2/15/2011)
In your example index 1 is redundant (the columns match exactly a left-based subset of another index), index 2 is not.
Wouldn't index 1 be used if a query...
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
February 15, 2011 at 3:58 pm
LutzM (2/15/2011)
Dave Ballantyne (2/15/2011)
First big change i need to do today is was told 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
February 15, 2011 at 3:14 pm
Triality (2/15/2011)
In the database there...
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
February 15, 2011 at 3:10 pm
Right idea, but you need to look at the process a little differently.
First, you need to determine all the multiple userid's in user_artist_owned, so we start with a query like...
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
February 15, 2011 at 2:59 pm
If you never have record edits, this is... one approach.
I've seen this method disseminated before as a quick and dirty way to perform that task.
My alternatives will depend on 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
February 15, 2011 at 2:51 pm
tfifield (2/15/2011)
Craig Farrell (2/14/2011)
Service Broker isn't used much because its complexity is threefold.
Craig,
Do you know of a decent tutorial on it? I've been meaning to get into Service Broker...
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
February 15, 2011 at 2:43 pm
SQL Guy 1 (2/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
February 15, 2011 at 10:00 am
Steve-3_5_7_9 (2/15/2011)
Thanks. I don't know what I'm talking about. I thought I experienced this but after looking through my notes, I cannot find anything; so just disregard me.
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
February 15, 2011 at 9:56 am
Jeff Moden (2/14/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
February 14, 2011 at 4:28 pm
As a silly question, since you're not getting results, can you double check something?
select Name
from [dbo].[Persons]
where Gender IN ('Male', 'Female')
Does this return anything?
The code itself looks fine offhand.
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
February 14, 2011 at 4:22 pm
Makes perfect sense.
I can't post images inline here so I'll try to explain this as descriptively as possible.
The general idea here is loop the loop.
First, get your table of prefixes...
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
February 14, 2011 at 4:19 pm
Jeff Moden (2/14/2011)
wolfkillj (2/14/2011)
Jeff Moden (2/14/2011)
Ok... the following function will pretty much blow the doors off of other splitter functions including some of my old ones.
WOW!!! That crash you...
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
February 14, 2011 at 4:02 pm
Service Broker isn't used much because its complexity is threefold.
1) If you've never worked with a messaging service you have to learn a bunch of new terminology.
2) You pretty much...
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
February 14, 2011 at 3:26 pm
Stefan Krzywicki (2/14/2011)
GilaMonster (2/14/2011)
Grant Fritchey (2/14/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
February 14, 2011 at 1:11 pm
Viewing 15 posts - 4,006 through 4,020 (of 5,678 total)