Viewing 15 posts - 4,156 through 4,170 (of 5,678 total)
palpacino (2/3/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 3, 2011 at 4:19 pm
tfifield (2/3/2011)
I'll try to look up my bench mark tests on this. I seem to recall that the case where ROW_NUMBER() would beat the CROSS APPLY/TOP 1 construct was...
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 3, 2011 at 4:14 pm
The reason that didn't work is you have a select statement before the metadata definition.
SELECT @Dummy = COUNT(*) FROM sys.tables
The first statement that isn't a set of some kind 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
February 3, 2011 at 3:56 pm
Steve Jones - SSC Editor (2/3/2011)
I rarely delete stuff, but that one went so sideways, with almost no technical info, that I decided to whack it.
Probably for the 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
February 3, 2011 at 3:53 pm
You're displaying the results as text, not grid, right?
Grid turns CHAR(10) and (13) into hidden characters... and a little testing on my part shows Lutz was right in the first...
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 3, 2011 at 3:39 pm
nbussel (2/3/2011)
@LutzM Thanks for your replyI have tested your suggestion and this gives me the output:
a b c
However I wanted the output to be:
a
b
c
It's this part: CHAR(13))
You want CHAR(10)...
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 3, 2011 at 3:15 pm
palpacino (2/3/2011)
I guess I was under the impression that this could...
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 3, 2011 at 3:12 pm
Mike, are there more senior DBAs on staff, or did you get volunteered to the position because noone else will do it? The reason I ask is to know...
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 3, 2011 at 3:09 pm
SanDroid (2/3/2011)
I was reading someplace that in MS SQL, the leaf level of a nonclustered index contains the clustered key columns that point back to the clustered index...
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 3, 2011 at 2:57 pm
The column in this you care about is 'Final Removal'.
I broke it down so you can see what each component of the function is doing.
Please test and confirm this will...
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 3, 2011 at 2:52 pm
nbussel...
Curious, the only time I know I've ever wanted my DB to do this work was when I had to feed a file for a mainframe consumption. Is that...
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 3, 2011 at 2:07 pm
How about just moving the date around to work within standard functionality?
Basically, take 3 months off an April date, for sorting purposes only, and make the system think that's january.
So,...
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 3, 2011 at 2:01 pm
Is this question highly simplified?
The reason I ask is a WHERE clause for where the status = 2 will return you your order ID's that have a 2 ( 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
February 3, 2011 at 1:58 pm
will s (2/2/2011)
TRAN LOGS:
- Will moving the tran logs from a 6-spindle RAID 5 to a 2-spindle RAID 1 actually slow writes down overall?...
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 3, 2011 at 1:39 pm
What Devesh posted above is the workaround. The reason is that SSIS wants to build out metadata, and it will use the first SQL statement of any kind 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
February 3, 2011 at 1:23 pm
Viewing 15 posts - 4,156 through 4,170 (of 5,678 total)