Viewing 15 posts - 4,276 through 4,290 (of 5,678 total)
Try swapping:
PatIndex('%"%,%"%',THE_LINE)),
-- with this:
PatIndex('%,"%,%",%',THE_LINE)),
Note where the additional commas are to detect beginning and ending doublequotes.
I may have an alternative for you but it's going to be a busy day. ...
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
January 24, 2011 at 11:12 am
Cool, okay. Some of your other brief descriptions contain verbage that I have to translate in my head to think if I know what you're talking about. Are...
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
January 24, 2011 at 11:10 am
There was a longer discussion a while back here:
http://www.sqlservercentral.com/Forums/Topic840059-360-1.aspx#bm840576
Nonclustered indexes lookup off the clustered. Non-clusters shouldn't have any user_lookups, only the clustered will when the NC's have to go...
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
January 24, 2011 at 11:05 am
Andy,
For those of us un-hip in the new termonology, this is just basically environmental configuration usage, right?
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
January 24, 2011 at 10:58 am
For starters, I would recommend you double check the necessity of SAP. It's a unique product and it can be expensive to find technical support for it. There...
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
January 24, 2011 at 10:36 am
I've got a bit of a concern about this process. Specifically in your place-holder mechanic.
My concern there is that you you only want to replace the commas between 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
January 24, 2011 at 10:18 am
The For XML bit is slightly modified by me, but mostly is borrowed from here:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
This code should do what you're looking for. First it normalizes the data so you...
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
January 24, 2011 at 10:05 am
Bhuvnesh (1/24/2011)
GilaMonster (1/24/2011)
Why is this query a problem?
the usage of resources if fine as per the query design.but i want to avoid Clus index scan or its cost %....
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
January 24, 2011 at 9:47 am
You know... randomly... has anyone thought about getting their SQL Servers tweet accounts? I think that'd be the second good use for tweeting I've seen, the first being 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
January 24, 2011 at 9:33 am
Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
Cool, that's awesome. And those...
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
January 24, 2011 at 9:32 am
Mohammed, so did I, but some of the background stuff I read regarding server licensing and CALs made me question it... was hoping someone had chatted up Microsoft recently...
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
January 24, 2011 at 9:28 am
To be clear here, because your data doesn't support your result directly, you want all the data in the list that's NOT defaulted to bid1/bid2/bid3...?
Nevermind, sorry, you answered this above,...
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
January 24, 2011 at 9:19 am
SJ, you mention the LUNs are dedicated, and that's normal... but are the physical spindles dedicated or are they shared to other systems so you can get a higher spindle...
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
January 24, 2011 at 9:15 am
Ron,
Only one problem, that pivots a comma delimited string into a multi-line table. He needs 1 row - delimited 1 row.
A quick and dirty solution would be a...
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
January 23, 2011 at 12:53 pm
Are slots involved in the calculation for overlaps? IE: Do you always have 20 slots available and need to make sure that you don't use more than 20 at...
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
January 23, 2011 at 5:13 am
Viewing 15 posts - 4,276 through 4,290 (of 5,678 total)