Viewing 15 posts - 271 through 285 (of 5,678 total)
SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/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
June 27, 2014 at 4:46 pm
kathy.plamann (6/27/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
June 27, 2014 at 4:41 pm
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/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
June 27, 2014 at 4:29 pm
Loner,
Don't feel bad. I failed my Microsoft interview so hard I excused MYSELF from the interviewing process. To give you an idea: I forgot GETDATE(). I was...
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
June 27, 2014 at 1:54 pm
Dennisql (6/26/2014)
if 3-4 tables join, does the order of table join in from clause matter? or the sql server will figure out the best execution plan for it?
Under most circumstances,...
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
June 26, 2014 at 6:27 pm
The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to grab the fees.
PM:...
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
June 26, 2014 at 4:56 pm
wendy elizabeth (6/26/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
June 26, 2014 at 4:53 pm
I'd approach this differently than T-SQL.
First, I'd be doing this in SSIS. Drop your distinct list of items off to a recordset object and use that as a feeder...
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
June 25, 2014 at 4:44 pm
Is this a simplified version of a much larger problem where the values in Table2 need to be pre-generated?
The reason I ask is because you're re-inventing the wheel called IDENTITY()...
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
June 25, 2014 at 4:22 pm
I need to see the sourcing code or specifics about the technique the originator is using Michael to really nail down why that's happening.
Jay's recommendation above is your best bet...
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
June 25, 2014 at 4:15 pm
rocky_498 (6/25/2014)
What I am trying to do, Extract the data from SQL table and Insert in Email Body and email to user. I got good article on Internet,...
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
June 25, 2014 at 4:13 pm
wendy elizabeth (6/25/2014)
1. Can I use a temp table called '##temp' in the firstdata set and have the other 4 datasets refere to '##temp'? I am asking...
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
June 25, 2014 at 3:55 pm
Koen Verbeeck (6/25/2014)
Evil Kraig F (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/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
June 25, 2014 at 3:46 pm
LOL,
Go, go mighty snark club! 🙂
I can't seem to find my favorite image of a crystal ball with the matrix code running down through it, otherwise I'd throw 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
June 25, 2014 at 3:44 pm
Do you have any downtime for this database/table?
I would expect a pretty heavy hit for this. Heavy enough that I'd recommend you do a table swap if you can....
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
June 25, 2014 at 2:39 pm
Viewing 15 posts - 271 through 285 (of 5,678 total)