Viewing 15 posts - 3,721 through 3,735 (of 5,678 total)
sherrerk (3/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
March 14, 2011 at 6:44 pm
In your derived column, try: (DT_STR,5)substring([ColumnName],1,5)
You have to force the data down directly to fit your result.
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
March 14, 2011 at 6:26 pm
barunpathak (3/14/2011)
"they booked a "FLIGHT" in Southwest"
If they're not escaping characters like this on the load, you have to use something other then a quoted identifier for text entries. ...
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
March 14, 2011 at 6:24 pm
I've used bitmasks in a similar method before, but it was to shortcircuit bad full-text indexing in 2k and prior. It's very useful, and allows you a reasonable volume...
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
March 14, 2011 at 5:52 pm
Gail as usual did her incredibly thorough job of hitting all the things I noticed, and of course, a few I didn't think of at first. 🙂
One thing she didn't...
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
March 14, 2011 at 5:17 pm
Salman Shehbaz-340356 (3/14/2011)
Recently I have come across a deadlock scenario on OLTP box (Sql server 2005) of a client
and found that it's caused by two stored procedures being called...
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
March 14, 2011 at 5:01 pm
Um, errr...
There are companies that base their entire living on doing financial calculations in large scale for businesses. For example, take a look at Advent Software.
Forget easily transcribed, these...
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
March 14, 2011 at 4:53 pm
A bit ignorant here, what's an MLM?
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
March 14, 2011 at 4:47 pm
As soon as you leave the base 256 character set of any language, you'll need nVarchar. You've got the jist of the difference. Under most circumstances most english...
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
March 14, 2011 at 4:44 pm
Use the TIME datatype instead of DATETIME for higher resolution on timings. It's accurate to 100 nanoseconds.
Edit: Left the window open in the background too long I see, I'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
March 14, 2011 at 4:43 pm
bruce.b.allen (3/14/2011)
Yes, that is all correct. I want to be able to save the new value to the variable I set in the DTS.Variables("Vname").Value and to have that value...
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
March 14, 2011 at 4:41 pm
bruce.b.allen (3/14/2011)
I currently use a script task to set the value of a variable. The script task works and sets the variable correctly.
However, if...
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
March 14, 2011 at 3:47 pm
You should be able to get more information in the SQL Server Logs, under the Management Node. Look at the most recent log file.
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
March 14, 2011 at 3:43 pm
jude-32296 (3/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
March 14, 2011 at 3:40 pm
To add to OPC's recommendations, a mediocre workaround that requires no dynamic SQL or code/logic reusage is to use the OPTIMIZE FOR structure. Be warned, it's fraught with peril,...
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
March 14, 2011 at 3:37 pm
Viewing 15 posts - 3,721 through 3,735 (of 5,678 total)