Viewing 15 posts - 841 through 855 (of 5,678 total)
It may just be the pathing. I've broken the XQUERY component out here directly as a local doc. See if this fixes the issue, else we'll have 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
January 29, 2013 at 4:16 pm
SQL_Enthusiast (1/29/2013)
Does that help?
I... think so.
Tell me if this does basically what you're looking for, and where, if anywhere, it goes awry:
DECLARE @CHG_ITEM TABLE(
CHARGE_BATCH_ID int,
CHARGE_ITEM_IDint,
REVENUE_SITE_IDint)
INSERT 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
January 29, 2013 at 3:57 pm
+1 to Sean's recommendation, OUTPUT is the way to go for this from SQL 2k5+.
The earlier alternatives are very, very messy and require a lot of coding to make your...
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 29, 2013 at 3:53 pm
*scratches head* This seems like standard ETL and warehouse work. Are you looking to know the keywords to reseach on? I'm not sure what you're looking for here.
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 29, 2013 at 3:50 pm
SQL_Enthusiast (1/29/2013)
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 29, 2013 at 2:06 pm
:blush:Yeah, that works too guys. Sorry about that, I'm chalking that one up to cold meds and a different DB system mixing up my head. Well, now 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 29, 2013 at 1:20 pm
EDIT: That query can't run as is, need to adjust for the group by.
Ah, apologies, I could have worded that a LOT more clearly. Easy enough. You take...
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 29, 2013 at 1:11 pm
UPDATE table SET newcol = @@SERVERNAME
Unless I'm really not understanding the question?
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 29, 2013 at 1:08 pm
That is a wild solution. Out of curiousity I went bounding through the intertubes to attempt to figure out what that does. It appears to suppress warning errors...
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 29, 2013 at 1:01 pm
Subquery it. IE:
SELECT * FROM
( SELECT max(abc) AS maxABC FROM #table)
ORDER BY
maxABC
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 29, 2013 at 12:46 pm
Pretty much, but you're not dealing with a server problem with PAGEIOLATCH. That's a Disk I/O wait type. Your Drive I/O is just huge and you're waiting until...
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 29, 2013 at 12:20 pm
As Pedro mentioned, size of table is important to seek vs. scan, but as is order of fields in the index and continuity. There are a number of rules...
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 29, 2013 at 12:19 pm
I finally managed to get my google-fu going, but posting for resolution.
The answer is.... (Hey, Maestro... drumroll please? Dude? Dammit)...
TRIM( (DT_STR,16,1252)Quantity) =="" ? (DT_STR,16,1252)NULL(DT_STR,16,1252) : Quantity
You have 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
January 23, 2013 at 5:56 pm
Heya Newbie,
We're gonna need a bunch more to help you on this one, including the .sqlplan and query. Check out the second link down in my signature on 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 23, 2013 at 5:22 pm
Abdul Rahman (1/23/2013)
We have simple Adhoc queries running from an application.
The query runs for hours and gets timed out.
At the same time I could see from Activity Monitor that it...
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, 2013 at 5:21 pm
Viewing 15 posts - 841 through 855 (of 5,678 total)