Viewing 15 posts - 4,216 through 4,230 (of 5,678 total)
drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate the opposite. ...
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 31, 2011 at 2:06 pm
I personally would actually approach this from SSIS, though there are varying discussions on that.
For SSIS, you'd multi-cast and do a number of twists on the datastream including conditional splits...
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 31, 2011 at 1:37 pm
Melanie Peterson (1/31/2011)
Also - I should've noted that the server where this sp resides is 2005, but REMSServer is...
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 31, 2011 at 1:31 pm
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
SELECT
mt.Item,
mt.UnitPrice,
mt.ChangeDate
FROM
#myTable AS mt
JOIN
(select
Item,
MAX( ChangeDate) AS MaxDate
FROM
#mytable
group by
Item
) AS drv
ON
mt.ChangeDate...
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 31, 2011 at 1:28 pm
Date is today.
0 is 1/1/1900, it's just a baseline number. It would appear they're trying to do time/month component strips.
For example, if I want the first day of this...
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 31, 2011 at 1:22 pm
Melanie Peterson (1/31/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
January 31, 2011 at 1:19 pm
I believe this article is what you were looking for:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
Search only articles here, and use the search string: For XML delimited string
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 31, 2011 at 1:04 pm
When an application installs Express, it usually is expecting complete control over the server itself. They're coding it for non-IT people to be able to use the product and...
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 31, 2011 at 12:24 pm
theBorch (1/31/2011)
Sadly the consultant touted his years of experience with the software, which is what in turn...
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 31, 2011 at 12:19 pm
sjimmo (1/31/2011)
I agree with everything that you said, but many times when pushed these vendors can use dbo access. They prefer SA because it is easier for them. I have...
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 31, 2011 at 12:17 pm
WayneS (1/31/2011)
Starting a new job today... I get to use whatever tools I want. I've used ERwin and PowerDesigner in the past. IMHO, ERwin...
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 31, 2011 at 12:11 pm
theBorch (1/31/2011)
This consultant was clueless when asked what permissions he needed to complete 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 31, 2011 at 12:01 pm
Brandie Tarvin (1/31/2011)
GilaMonster (1/31/2011)
Brandie Tarvin (1/31/2011)
If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?
He was pretty diplomatic about it. Far...
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 31, 2011 at 11:15 am
scorpianprince (1/30/2011)
I have a job to kill all the sleeping connections to my server, now i want to give access to this job to one of my user how...
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 30, 2011 at 5:03 pm
Yes, because you have one table with two foreign keys.
Now, be careful here. If you cascade delete/update both those keys, any change in either table will affect the center...
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 30, 2011 at 1:08 am
Viewing 15 posts - 4,216 through 4,230 (of 5,678 total)