Viewing 15 posts - 256 through 270 (of 5,678 total)
Asynchronous script transform (google that phrase) to transform the input properly would be my recommendation here. You have a variable set of inputs you want to control for.
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
July 10, 2014 at 12:55 pm
dbo.Split is not a built in function. They're referencing building a function to do that, such as the following:
http://www.sqlservercentral.com/articles/Tally+Table/72993/
What you basically do is turn the comma delimited string 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
July 7, 2014 at 6:39 pm
GilaMonster (7/7/2014)
EVE OnlineThat's one of his more comprehensible posts.
I gave that game up about 5 years ago, and I was late to the party even then. After a year...
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
July 7, 2014 at 6:26 pm
Your website logs in (usually) via a different login than you do. The security for that login needs to be reset on the restored database. What happens 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
July 7, 2014 at 6:19 pm
KGJ-Dev (7/7/2014)
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
July 7, 2014 at 6:17 pm
dndaughtery (7/7/2014)
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
July 7, 2014 at 4:09 pm
First, having to keep your schema intact across all dependant objects and avoiding SELECT * queries is a good thing.
However, there are a few approaches. The line by line...
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
July 7, 2014 at 3:35 pm
Crap, you're right Phil. Thank you for the correction. Apologies, OP.
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
July 4, 2014 at 5:15 am
I realize this is an older thread, but since it got woken up from it's cave, what's being asked for here is a GREATEST() function.
There is a thread and some...
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
July 3, 2014 at 6:35 pm
I know we're derailing this thread, but I'll respond to your final bit first:
the majority of that work is not firefighing. There are always issues that crop up, you fix,...
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
July 3, 2014 at 4:33 pm
Still being in 2008, I'm not sure I can speak directly to Package Parameters.
However, I can speak to configurations in general, which is what it sounds like you're describing.
Personally, 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
July 3, 2014 at 4:24 pm
Anytime I've worked in the healthcare industry, two things drove our regulation and auditing.
1) Our Legal Department, leading to
2) Our custom code to abide by their requirements.
I've never (in 9...
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
July 3, 2014 at 1:50 pm
I agree with Phil. You're trying to normalize data. I'd recommend, for this particular instance, to use SQL. Either with the UNION or with Unpivot.
If you need...
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
July 3, 2014 at 1:43 pm
winston Smith (7/3/2014)
dan-572483 (7/3/2014)
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
July 3, 2014 at 1:41 pm
SQLRNNR (6/30/2014)
Lynn Pettis (6/29/2014)
Koen Verbeeck (6/29/2014)
Lynn Pettis (6/28/2014)
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
June 30, 2014 at 11:14 am
Viewing 15 posts - 256 through 270 (of 5,678 total)