Viewing 15 posts - 4,666 through 4,680 (of 5,678 total)
Personally, if you're going to go through the effort of maintaining separate file groups, you need the separate physical spindles to get the true benefit from them for optimization. ...
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
December 8, 2010 at 3:42 pm
drew.allen (12/8/2010)
How does the 'GO' in the dynamic @sql stop the proc from compiling correctly? It doesn't, because it compiles and executes just fine on my system. 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
December 8, 2010 at 3:33 pm
traughberk (12/8/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
December 8, 2010 at 3:24 pm
jcrawf02 (12/8/2010)
But do you have Stingray boots?I'm safe, I'm under-qualified 😉
Nope, got one stiffened into a kneeboard, though.
I'm pretty sure I'm underqualified too, but I can't resist sometimes.
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
December 8, 2010 at 3:22 pm
Jack Corbett (12/8/2010)
GilaMonster (12/8/2010)
Jack Corbett (12/8/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
December 8, 2010 at 2:41 pm
KS-321165 (12/8/2010)
Thank You! You saved me a ton of time.
You're welcome. If there's any bits and pieces of that you don't understand come back and ask. You're going...
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
December 8, 2010 at 2:34 pm
KS-321165 (12/8/2010)
Thanks. I am learning CTE and so it was helpful when you broke it down, but how do you put all this in one query?:-)
SELECT
drvStart.ResourceID,
DATEADD( mm, DATEDIFF( mm, 0,...
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
December 8, 2010 at 2:24 pm
Jack Corbett (12/8/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
December 8, 2010 at 2:11 pm
GSquared (12/8/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
December 8, 2010 at 2:06 pm
jayoub1 (12/8/2010)
I support...
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
December 8, 2010 at 1:15 pm
teutales (12/8/2010)
I'm new to ServiceBroker. I want to rebuilt the indexes on an express server every night with the service broker. So my target is one servicebroker which manages all...
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
December 8, 2010 at 1:13 pm
Randy, I believe this is what you're looking for, but honestly, not entirely sure:
ISNULL( <FIELD>) = TRUE ? NULL(DT_DATE) : (DT_DBTIMESTAMP) <FIELD>
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
December 8, 2010 at 12:37 pm
CirquedeSQLeil (12/8/2010)
Grant Fritchey (12/8/2010)
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward...
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
December 8, 2010 at 12:30 pm
Well, the first thing I'd ask is what grunt work would you like to be able to offload to these interns? Are these first year interns (so I'd assume)?
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
December 8, 2010 at 12:28 pm
I broke this into CTE's because it's easier to see the methodology that way. You could do this all in one query if you wanted. The key 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
December 8, 2010 at 12:18 pm
Viewing 15 posts - 4,666 through 4,680 (of 5,678 total)