Viewing 15 posts - 2,596 through 2,610 (of 5,678 total)
Koen Verbeeck (9/14/2011)
sqlfriends (9/14/2011)
Running in design time will result in using the connections from the connection manager rather than you file.
Running...
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
September 14, 2011 at 12:40 pm
Congratz Jeff, Float's needed for microscopic percentages and the like (money in particular is problematic), I personally prefer decimal/numeric to avoid rounding issues as I usually deal with financial data...
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
September 14, 2011 at 12:24 pm
Kevin Dahl (9/14/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
September 14, 2011 at 12:20 pm
SJanki (9/14/2011)
Can the currently stored data in the nText field in 2k5 be used in Acrobat? If not, the data will not suddenly 'work' if you move it to...
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
September 14, 2011 at 12:18 pm
SJanki (9/13/2011)
I still wouldn't trust the data though if you can't get it to function from the nText in the first place
Hi,
I did not understand what do you mean...
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
September 14, 2011 at 11:14 am
SQLkiwi (9/13/2011)
My personal favourite, in many circumstances (and assuming Enterprise Edition) is same database with sensible partitioning/file group/SAN arrangements. Proper configuration can make...
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
September 13, 2011 at 6:18 pm
SJanki (9/13/2011)
the older version, SQL Server 2005, was just storing the documents in nText type column, they do not have to display the file.
In my application I have to display...
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
September 13, 2011 at 6:06 pm
As Wildcat mentioned, you want a ForEach Loop object in the Control Flow. It accepts wildcards, so you'll be searching for files in the path with ABCD*.txt. 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
September 13, 2011 at 6:00 pm
I appreciate the honesty. There's a few things you'll want to look into to understand optimizing Dynamic SQL in particular.
First, you want to explore the plan cache. Then,...
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
September 13, 2011 at 5:54 pm
The same thing we do every night, Pinky.
We try to take over the WORLD!
Honestly, I'm here on SSC when it's slow, or I'm off trying to research something, or still...
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
September 13, 2011 at 4:36 pm
Self service restores can be a little dicey, but I've been in places where QA had that level of control. As far as the job is concerned, the job...
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
September 13, 2011 at 4:34 pm
If you moved your app to the same cloud, I might be able to see it. At least then you're not doing double bandwidth, even for OLTP systems. ...
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
September 13, 2011 at 4:32 pm
SJanki (9/13/2011)
Any idea how can I convert nText data to varbinary(max)
I first did a cast from ntext to...
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
September 13, 2011 at 3:18 pm
Matt Miller (#4) (9/12/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
September 12, 2011 at 8:00 pm
I'm not sure of how your calculation would work. Can you help explain what the '95th' percentile is? I can't seem to easily grok the math that came...
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
September 12, 2011 at 2:46 pm
Viewing 15 posts - 2,596 through 2,610 (of 5,678 total)