Viewing 15 posts - 2,311 through 2,325 (of 5,678 total)
chris 81958 (11/17/2011)
My database has a timepoint that incorporates data and time; e.g., 2010-12-01 17:00:00. I would...
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 17, 2011 at 2:48 pm
bubs (11/17/2011)
Name | FilteredHours | NonFiltered
Steve | 20 ...
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 17, 2011 at 2:39 pm
AGH, my eyes! ... and formatting is eaten.
Can you edit your posts and wrap your code with the 'ifCode' shortcuts you see on the left? The one 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
November 17, 2011 at 2:32 pm
My guess would be heuristics and the tipping point.
Is 'my_column' in the actual clustered index? If not, try using it as an include in the index definition. You'll...
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 17, 2011 at 2:29 pm
This is in a transformation script component?
You need to include the equivalent to this VB in your Catch.
dts.TaskResult = dts.Results.Failure
That should cause a hard stop on the row that's caught,...
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 17, 2011 at 2:26 pm
Review the spid doing the initial call after reboot, and review its wait stats. Find out WHY that first one is taking so long, you'll have a better idea.
My...
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 17, 2011 at 1:44 pm
As mentioned, the cause of this is duplicate key data in multiple tables.
from
d_m m
left join
[ref].[dbo].[D_HDS] rg on
rg.HDCode = m.G_DID
left join
[ref].[dbo].[D_HDS] ri on
ri.HDCode = m.I_DID
left join l_Qcat c...
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 17, 2011 at 11:54 am
Is it safe to assume that this:
RIGHT JOIN dim_date
...
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 17, 2011 at 10:52 am
Brandie Tarvin (11/17/2011)
I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File...
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 17, 2011 at 10:48 am
Brian Ki (11/16/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 16, 2011 at 7:24 pm
Jeff Moden (11/16/2011)
Oh, my apologies... I lost track of this thread. Glad someone posted against it to refresh it in my inbox.
Yeah, just hoping the OP comes back 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
November 16, 2011 at 2:02 pm
Ninja's_RGR'us (11/15/2011)
Ever tried to get your car fixed without taking it to a mechanic? Pretty much same thing...
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 16, 2011 at 1:28 am
This is horribly painful to do via SQL. This is best off done in the front end.
The short form: You need to pivot, do a running total, 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
November 16, 2011 at 1:21 am
Contract to Hire is pretty much the new version of the wait for 3 months before any of your benefits thing. The word is escaping me at the moment....
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 16, 2011 at 1:17 am
Comments are in the code.
DataBuild:
IF OBJECT_ID('tempdb..#tester') IS NOT NULL
DROP TABLE #tester
CREATE TABLE #tester
( TimeOfEntry...
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 15, 2011 at 5:33 pm
Viewing 15 posts - 2,311 through 2,325 (of 5,678 total)