Viewing 15 posts - 1,321 through 1,335 (of 5,678 total)
john.bush (8/6/2012)
I checked everything you mentioned and have got positive results. I seem to have left the RPC and RPC Out at defaults (False). What does RPC stand...
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
August 6, 2012 at 3:35 pm
asm1212 (8/6/2012)
Yeah no offense but my view is much larger than that, and i was trying to dumb it down...
Which is why you got a simplified answer.
I have tried using...
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
August 6, 2012 at 3:23 pm
john.bush (8/6/2012)
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
August 6, 2012 at 3:09 pm
A question. Are you trying to store the file, or the information IN the file for full-text indexing?
If you're just trying to store the file, you want VARBINARY(MAX). ...
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
August 6, 2012 at 3:00 pm
miapjp (8/6/2012)
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
August 6, 2012 at 2:57 pm
I'd be willing to assist on QotD validations, but my free time has constrained signficantly lately so I certainly couldn't guarantee timeliness (ie: under two weeks)
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
August 6, 2012 at 2:48 pm
You'll want to run sp_updateview after you're done changing the underlying schema. If the view(s) are schemabound you'll have to drop and recreate them after you've made your modifications.
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
August 6, 2012 at 2:47 pm
bsclyde (8/2/2012)
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
August 2, 2012 at 5:54 pm
I stayed away from this thread for a bit because it hits a few demons in my career. I've also had a few blessings.
One of my managers once told...
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
August 2, 2012 at 5:37 pm
Nope.
The best you can do is grab an estimated execution plan and that'll attempt to determine it off statistics, but really... nope.
You COULD do a SELECT COUNT(*) AS cnt FROM...
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
August 2, 2012 at 4:19 pm
polkadot (8/2/2012)
Do I need to first order the dates...
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
August 2, 2012 at 4:17 pm
I'll second (third?) the delimited string splitter technique and use an inline table function for a single parameter set.
XML is an excellent alternative in 2k5 for when you have pairs...
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
August 2, 2012 at 4:11 pm
I've personally never ran into anything that can convert Access DAO.SQL to T-SQL effectively. There's just enough differences and assumptions in the two that they don't play nice directly...
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
August 2, 2012 at 4:05 pm
Michael Valentine Jones (8/2/2012)
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
August 2, 2012 at 3:02 pm
I can't see the item in discussion, unfortunately, because that site is blocked by websense.
However, if I can toot my own horn and following along with the discussion and your...
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
August 2, 2012 at 2:34 pm
Viewing 15 posts - 1,321 through 1,335 (of 5,678 total)