Viewing 15 posts - 2,191 through 2,205 (of 5,678 total)
nico van niekerk (12/1/2011)
I ran both and compared the outputs: they are identical.
Did you compare the two final execution plans as well? That's where the keys to 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
December 1, 2011 at 1:14 pm
Congratz Gus. I think I'd go mad doing anything for 21 years, but I'm under the understanding that it's very pleasant with the right person. Go you! :w00t:
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
December 1, 2011 at 12:02 pm
CELKO (11/29/2011)
Quit computing and start thinking in data.The next trick is a report period calendar. It gives a name to a range of dats.
Who gives a flight? ...
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
December 1, 2011 at 11:56 am
#2 is my usual method, though I would have an alteration I'd recommend. With everything going to the same final destination include a 'union all' component and have 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
December 1, 2011 at 11:47 am
Jeff Moden (11/29/2011)
Evil Kraig F (11/29/2011)
Jeff Moden (11/21/2011)
Evil Kraig F (11/21/2011)
Any SQL services or tools to aid in this?
Not really.
What about table partitioning or even partitioned views?
You're correct, Jeff, I'm...
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
November 29, 2011 at 7:16 pm
Welsh Corgi (11/29/2011)
tfifield (11/29/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
November 29, 2011 at 7:14 pm
Not exactly, and without more columns I'm slightly confused. This sounds like an update statement, something you try to avoid in SSIS. If you were adding or transforming...
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
November 29, 2011 at 5:32 pm
Yes, with exceptions. Under standard circumstances (no TDE, san encryption, etc) then yes, a non-corrupt mdf can be completely restored elsewhere. You may get slight data loss or...
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
November 29, 2011 at 5:02 pm
You're going to want to use the FOR XML method, just without a delimited separator.
Check out this article: http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
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
November 29, 2011 at 4:56 pm
Denise McMillan (11/29/2011)
select number, avalue, (select x.nvalue from valuestbl as x where a.number = x.number and x.number like...
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
November 29, 2011 at 4:53 pm
SQL Dude-467553 (11/29/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
November 29, 2011 at 4:08 pm
DavidL (11/29/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
November 29, 2011 at 4:01 pm
Tristan Chiappisi (11/29/2011)
I'm looking for an answer that seems relatively simple; however, my brain is blocked. I'm looking to partition my table from 365 DayOfYear (DATEPART(DY,GETDATE())) to a 3 (1095)...
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
November 29, 2011 at 3:56 pm
Go the other way. You need to think in days off the base year.
;WITH cte AS
(SELECT '20100105' AS dt UNION ALL
SELECT '20090603' UNION ALL
SELECT '20080321' UNION ALL
SELECT '20070910')
select
DATEDIFF( dd,...
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
November 29, 2011 at 3:46 pm
cafescott (11/29/2011)
Out of curiousity, what are you going to do with hard tables in a SELECT INTO when it's ran concurrently? This technique is almost explicitly used for #tmp tables...
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
November 29, 2011 at 2:39 pm
Viewing 15 posts - 2,191 through 2,205 (of 5,678 total)