Viewing 15 posts - 5,161 through 5,175 (of 5,678 total)
HelsUK (10/29/2010)
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
October 29, 2010 at 5:03 pm
Sorry for that then, the hard coded values are usually reserved for homework problems.
This looks a LOT like a QotD type of trip up. Your boss quizzing your skills...
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
October 29, 2010 at 4:59 pm
Ricardumus (10/29/2010)
Hello.I just need a simple description of this query and its function.
ROUND(DATEDIFF(d,'12/01/2009', DATEADD(d,-1,'12/01/2010'))/365.00,1) AS [Years]
It's a trick question. What textbook and chapter? We can probably help...
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
October 29, 2010 at 4:47 pm
HelsUK (10/29/2010)
I have a SSIS package that should truncate my staging table, reseed the identity value to 100 and then insert some data into the staging table.
The problem is that...
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
October 29, 2010 at 4:28 pm
Alvin Ramard (10/29/2010)
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
October 29, 2010 at 4:08 pm
Set zoom to visible level (75%-100%).
Database Diagram menu, copy diagram to clipboard.
MSPaint - Paste - Print.
Perfect? No. But it works.
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
October 29, 2010 at 4:03 pm
I believe this is because SSIS won't refresh metadata at runtime. This part confuses me:
Weirdly, it did work twice - the only change I made was to add 'GO'...
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
October 29, 2010 at 3:58 pm
With no test data you'll have to adapt this to your DDL/structure, but this is one approach:
SELECT
REVERSE( LEFT( REVERSE(Col1), CHARINDEX( '.', REVERSE(Col1) ) -1 ) ),
count(*) as NumOccur
FROM
table
GROUP BY
REVERSE( LEFT(...
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
October 29, 2010 at 3:25 pm
Addendum, some googled links on the topic:
The last post of this:
http://www.sqlbi.com/Default.aspx?tabid=72&forumid=12&threadid=665&scope=posts
These all point to making sure the destination is as large as the source, even with manipulation.
This may help a...
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
October 29, 2010 at 3:04 pm
If I'm reading that right it's not the VARCHAR() causing the problem, it's the INT32 field. Something in the source data is one REALLY big number.
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
October 29, 2010 at 2:59 pm
GilaMonster (10/29/2010)
Write a query that returns the FirstName 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
October 29, 2010 at 2:57 pm
Wut? You want to autogenerate... a timestamp column?
Are you PURPOSELY coding to obfuscate data? What the heck?
If you need a larger identity column, go to bigint.
If you're trying...
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
October 29, 2010 at 2:52 pm
Hub/Router fried/shorting? Heartbeat nic cards shorted? I'd look for a physical failure, not a software one, after a massive power failure.
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
October 29, 2010 at 2:27 pm
andrew gothard (10/29/2010)
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
October 29, 2010 at 2:18 pm
Serial/Quirky update in a temp table, a while loop, or possibly a recursion cte. I don't have time right now to convert your data into a usable test structure.
If...
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
October 29, 2010 at 2:02 pm
Viewing 15 posts - 5,161 through 5,175 (of 5,678 total)