Viewing 15 posts - 3,991 through 4,005 (of 5,678 total)
niall.baird (2/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
February 16, 2011 at 4:27 pm
Just a quick question, is this an ADP that connects to a SQL 2k5 backend, or an actual MS Access database? The error is SQL so I assume you're...
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
February 16, 2011 at 4:21 pm
Jole84 (2/16/2011)
Andreas Goldman (2/16/2011)
WHERE [DATE] >= DATEADD(HOUR, - 1, GETDATE())
hm... this query gets all data from table. My last record was inserted 08/02/2011 11:44:56 PM so
it must return zero rows...
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
February 16, 2011 at 4:16 pm
Well, yes and no.
First in the script task you have to expose the variables to the script task in the Script Task editor window, at the least as ReadOnlyVariables.
If 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
February 16, 2011 at 4:12 pm
Well, it's the long way around the barn these days, but it's not that uncommon in SQL 2k and back. However, you always start with the inside moving out....
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
February 16, 2011 at 11:22 am
Most likely they were stale when you did the backup. To avoid things like this, do your reindexing/statistic updating before you do your backups.
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
February 16, 2011 at 11:16 am
Mine tends to be whatever mood strikes me at the time, or can be triggered by a conversations.
I believe this one was from a recent conversation where it was agreed...
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
February 16, 2011 at 11:11 am
Yep, different errors. These are easier to deal with:
OnError CRM CRM\Administrator Package {32833F60-011C-44C1-AE01-DE591DC521B8} {0A292E65-3966-4E42-810E-AF6857A821DC} SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB...
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
February 16, 2011 at 11:05 am
thepotplants (2/15/2011)
I haven't heard of tally tables, so I'll have a look. Thanks for the suggestion.
No problem. You'll find the Tally and/or Calendar table much quicker than any while...
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
February 15, 2011 at 11:44 pm
Triality (2/15/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
February 15, 2011 at 11:38 pm
You got your code in my THREAD! ARGGGHHH... We need to take this outside!
I believe, if memory serves, there was an algorithm for using XML instead of 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
February 15, 2011 at 11:30 pm
The three standard ways to handle this with T-SQL would be the following:
- While Loop (slowest but most common)
- Calendar Table (requires upkeep)
- Tally Table ( requires understanding of using...
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
February 15, 2011 at 8:24 pm
dlatch (2/15/2011)
It was actually an SSIS package that I had written. Doing a lookup against the key and column splits on the critical tested fields. ...
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
February 15, 2011 at 6:57 pm
Triality (2/15/2011)
Ah thats exactly what I was looking for, makes complete sense! Thanks Craig!
My pleasure. I've been crash coursing in more advanced SSIS for the last two months...
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
February 15, 2011 at 5:29 pm
LutzM (2/15/2011)
Therefore, it's sometimes referenced as T(c) which is Table(column).
The one column itself holds...
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
February 15, 2011 at 5:25 pm
Viewing 15 posts - 3,991 through 4,005 (of 5,678 total)