Viewing 15 posts - 4,891 through 4,905 (of 5,678 total)
jordantx (11/18/2010)
Does padding mean the same thing as fillfactor? Sorry for my ignorance.
Yep. I use bad slang on occassion, sorry. I'll try to stop doing it 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
November 18, 2010 at 9:33 pm
Sorry, stayed home sick today, just catching up with SSC. So your primary costs are definately in the executables. Hm, I'd definately look into the drive builds. ...
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
November 18, 2010 at 8:56 pm
Danky,
This should work, depending on datatypes:
SELECT ISNULL( col1, 'NULL'), ISNULL( col2, 'NULL),....
FROM Table
WHERE x > y
FOR XML RAW('Movement'), ELEMENTS, ROOT('SPEI')
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
November 17, 2010 at 5:46 pm
pavan_srirangam (11/17/2010)
But not in tempdb its on user db.
How I do this in prod.
Dividing into equal no of files and 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
November 17, 2010 at 5:43 pm
Steve Jones - SSC Editor (11/17/2010)
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
November 17, 2010 at 4:58 pm
Grasshopper, just FYI, this does a LOT more than gapcheck. Also this doesn't seem that horribly painful, cursor optimization techniques shouldn't be necessary here.
Any chance we can see 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
November 17, 2010 at 4:56 pm
:ermm: Yeah, you caaaannnn.... but why would you want an additional 4 .ndf files with no other purpose to them? Just splitting the files without a purpose 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
November 17, 2010 at 4:42 pm
Of some interest to your results may be that a Cold Buffer is not necessarily an unused buffer.
See this article:
In particular:
SQL Server understands the time of last access to buffers...
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
November 17, 2010 at 4:17 pm
Jason Miller-476791 (11/17/2010)
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
November 17, 2010 at 3:57 pm
Welcome back, Jordan. You've come a long way since your last discussion. Glad to see your interest hasn't waned when you saw the size of the hill you've...
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
November 17, 2010 at 3:05 pm
C'mon Joe. Not only is the table an obvious example instead of true DDL (there is no way someone could use THAT many reserved keywords at once... just... no...),...
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
November 17, 2010 at 12:44 pm
Alright, another business logic question, then.
The way you're approaching it, with this dataset:
( 1, 2, 3 ),
( 4, 1, 6),
( 1, 7, 8),
( 9, 2, 10),
(11,12,...
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
November 17, 2010 at 12:28 pm
EDIT: Whoops, cross posted by accident, had two windows going at once and punched this into the wrong one. Correct response below:
You want a splitter function. Check this...
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
November 17, 2010 at 11:25 am
biren (11/17/2010)
Hello,This works thank you very much... A ++ SUPPORT !!
Support? We get paid for this? *scratches head* Hey, Steeeeeeeve..... where's my check dood?!
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
November 17, 2010 at 11:24 am
A few things in this make me question the proc in general.
Jason Miller-476791 (11/17/2010)
CREATE UNIQUE INDEX ix2 on #t1 ( c2...
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
November 17, 2010 at 11:22 am
Viewing 15 posts - 4,891 through 4,905 (of 5,678 total)