Viewing 15 posts - 166 through 180 (of 5,678 total)
5 years experience? I expect to hear stories, end to end solutions. I expect to hear what blew up under their fingertips when the rolled something to production...
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
August 5, 2014 at 12:58 pm
Lynn Pettis (8/1/2014)
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
August 1, 2014 at 5:21 pm
A couple of questions.
You're in SQL 2014, and want to select an INT. Have you looked at SEQUENCE? It does exactly that.
If you want to lock rows for...
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
August 1, 2014 at 3:17 pm
dan.james (8/1/2014)
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
August 1, 2014 at 3:07 pm
churlbut (7/31/2014)
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
July 31, 2014 at 2:00 pm
Now now, there are cases where I can feel the frustration of the OP practically shouting "Just tell me the damned keywords and I'll look it up on my own!"...
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
July 30, 2014 at 6:37 pm
ipisors (7/30/2014)
Because the documentation on IDENTITY INSERT states that you have to explicitly pass the value to insert into PK field.Not true?
Not true from the way you're reading...
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
July 30, 2014 at 6:32 pm
ipisors (7/30/2014)
So you're passing values explicitly in the sql insert. I know how to do that.
I...
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
July 30, 2014 at 6:19 pm
It's that easy. Just use a column list in the INSERT INTO statement for both sides to directly control who goes in what position.
IE:
CREATE TABLE #tester
(IdCol INT IDENTITY( 1,...
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
July 30, 2014 at 5:08 pm
SQLRNNR (7/30/2014)
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
From one particular vendor,...
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
July 30, 2014 at 4:35 pm
I'm not even sure what you're asking, so I can't find chapter and verse to help with your other questions.
Can you setup two actual tables with just enough data 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
July 30, 2014 at 3:37 pm
Sean Lange (7/30/2014)
Evil Kraig F (7/30/2014)
churlbut (7/30/2014)
We just had a meeting a few months ago given by a DBA to us developers...
Big advice to us was to take the Items...
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
July 30, 2014 at 3:34 pm
churlbut (7/30/2014)
We just had a meeting a few months ago given by a DBA to us developers...
Big advice to us was to take the Items in a WHERE Clause (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
July 30, 2014 at 2:59 pm
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
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
July 30, 2014 at 2:53 pm
patrickmcginnis59 10839 (7/30/2014)
Just wished it didn't happen because of how easy they are to find, I'm certainly not "data mining" thats for sure.
Didn't mean to imply you were. ...
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
July 30, 2014 at 1:57 pm
Viewing 15 posts - 166 through 180 (of 5,678 total)