Viewing 15 posts - 3,646 through 3,660 (of 5,678 total)
HIPAA, under most circumstances, hit me harder then SOX. SOX mostly forced change control into existence for the cowboy shops. It's been taken to rediculous extremes on occassion,...
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 18, 2011 at 4:13 am
Jeff Moden (3/17/2011)
David Burrows (3/17/2011)
Koen Verbeeck (3/17/2011)
Jeff, stop interfering in SSIS threads. 😛 😀
Ahhh!!! Be nice to Jeff, he can't help it if he is stuck in a T-SQL sandbox...
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 18, 2011 at 4:10 am
leon.booij (3/18/2011)
I want to convert a varchar column to a numeric(9,2) columnbut the vachar column has also negative values
ColumnA
1.450,40
142,07
83,71-
So, you're expecting to see:
1.450,40
142,07
-83,71
?
That's not 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
March 18, 2011 at 4:07 am
Eric, Rahuzz above is on the money for your solution here. Let us know if you run into problems with that solution. If you do, please post 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
March 18, 2011 at 4:06 am
Ian is correct that it's tough to decipher your issue from this end with the description, however...
Your code needs to confirm there is a second underscore in the string before...
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 18, 2011 at 4:04 am
Hey JJ,
Sorry it's late and I'm glad you found your solution.
What we were trying to get out of you was something like this, which if you'd read the article end...
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 18, 2011 at 3:59 am
The cure is because an xml specific column will index itself internally, and I don't have all the rules handy.
Can you doublecheck your laptop and the server engine you're 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
March 18, 2011 at 3:56 am
Ahhh, sorry San, I misread it on the first pass. Have to bear with me, it's ~3AM here, after a day in America celebrated by much alcoholic intake. 😀
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 18, 2011 at 3:52 am
Leon, what you wrote in SQL and what you see makes sense to me.
What do you WANT to see for those items?
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 18, 2011 at 3:46 am
Just to add to Jim's recommendation, google is your friend here.
T-SQL tutorial in google will resolve a number of possibilities.
Two quick ones (I don't know their worth, but anything will...
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 18, 2011 at 3:36 am
Jim McLeod (3/17/2011)
george sibbald (3/17/2011)
rollback -dbcc shrinkfile with the emptyfile option, followed by alter database command to remove the file.
That would work (and was my first thought too), but I...
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 18, 2011 at 3:33 am
alexus8888 (3/18/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 18, 2011 at 3:29 am
San, this doesn't make sense from this side. If you're selecting email_1, email_2 ... that sounds like different columns, yet you state it's one column.
can you right-click, script 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
March 18, 2011 at 3:26 am
Rem70Rem (3/17/2011)
What are the steps to rollback if needed?
Generate a new filegroup, move *everything* into the new filegroup. Rebuild the original Primary as desired, move everything back, and remove...
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 17, 2011 at 4:17 pm
george sibbald (3/17/2011)
don't quite understand why myself, but as disk technology moves forward old truths can become outdated.
I still would not recommend it as a default approach to file layout,...
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 17, 2011 at 4:12 pm
Viewing 15 posts - 3,646 through 3,660 (of 5,678 total)