April 18, 2011 at 2:02 pm
Grant Fritchey (4/18/2011)
GilaMonster (4/18/2011)
CirquedeSQLeil (4/18/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
Yup. Booked flights so that I get 4 and a bit days at leisure in the UK after the course. Haven't yet decided where I'll go.
Oh man, they couldn't do it in July. I'll be over there from the 11th to the 22nd.
I know, the ultimate in bad timing. I'm flying home on the 29th June.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 19, 2011 at 12:40 am
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
My bank account is crying so loud, I can't even hear London calling ....
( altough it reminds me of a great song some decades ago by The Clash [howling]x6 )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 19, 2011 at 12:43 am
ALZDBA (4/19/2011)
( altough it reminds me of a great song some decades ago by The Clash [howling]x6 )
Thanks, this will be stuck in my head for the rest of the day 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 19, 2011 at 1:06 am
Koen Verbeeck (4/19/2011)
ALZDBA (4/19/2011)
( altough it reminds me of a great song some decades ago by The Clash [howling]x6 )
Thanks, this will be stuck in my head for the rest of the day 🙂
That has been my good deed for the day 😀
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 19, 2011 at 7:11 am
ALZDBA (4/19/2011)
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
My bank account is crying so loud, I can't even hear London calling ....
( altough it reminds me of a great song some decades ago by The Clash [howling]x6 )
Yeah, I was there too...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 19, 2011 at 11:42 am
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
Is it bad that after April Fool's the first thing I did on a comment about Celko was double check I wasn't getting Rick-Rolled again? 😛
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
April 19, 2011 at 12:07 pm
Craig Farrell (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.Is it bad that after April Fool's the first thing I did on a comment about Celko was double check I wasn't getting Rick-Rolled again? 😛
Woohooo! I win!!!!
:w00t::w00t::w00t:
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 19, 2011 at 12:22 pm
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe's answer, while demanding that others follow published standards, was itself a gross violation of data architectural standards. Though I have to admit, I'm getting tired of calling him on his hypocrisy.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 19, 2011 at 12:31 pm
I'm going to violate the rule and add a "technical" question to The Thread under the caveat that I don't really need an answer for a problem so much as I'm just curious...
At my workplace, we often have a need to manually INSERT hard data from one environment to the next. Say I have Table1 on my Dev database. I want to take some or all of that data and insert it into Table1 in Test. Now, I can't use the Import / Export wizard because this insertion is part of our SDLC. So, while I could create an SSIS package (or use the wizard to do it), sometimes it's just easier, especially with small tables, to force the data into an INSERT T-SQL statement.
Some people are fond of doing this as multiple single INSERT statements (INSERT ... SELECT ...; INSERT .... SELECT ...;). Me, I like using 1 INSERT clause and then a SELECT .... UNION ALL SELECT ... type of format.
If you had to choose between the two T-SQL options, which would you choose and why?
April 19, 2011 at 12:38 pm
Brandie Tarvin (4/19/2011)
Some people are fond of doing this as multiple single INSERT statements (INSERT ... SELECT ...; INSERT .... SELECT ...;). Me, I like using 1 INSERT clause and then a SELECT .... UNION ALL SELECT ... type of format.If you had to choose between the two T-SQL options, which would you choose and why?
Bwah, it depends 🙂
The 1 INSERT clause is immediately a single batch/transaction, while the multiple INSERT ... SELECT can more easily be seperated in multiple batches/transactions.
If it was quite a lot of data, I would go for the multiple causes, just to avoid that the whole transaction could roll back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 19, 2011 at 1:14 pm
Brandie, if I was using 2008, I'd use the INSERT Values(), (), () thing. If 2005, most likely the union all, if the # of rows wasn't too high.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 19, 2011 at 1:16 pm
Brandie Tarvin (4/19/2011)
I'm going to violate the rule and add a "technical" question to The Thread under the caveat that I don't really need an answer for a problem so much as I'm just curious...At my workplace, we often have a need to manually INSERT hard data from one environment to the next. Say I have Table1 on my Dev database. I want to take some or all of that data and insert it into Table1 in Test. Now, I can't use the Import / Export wizard because this insertion is part of our SDLC. So, while I could create an SSIS package (or use the wizard to do it), sometimes it's just easier, especially with small tables, to force the data into an INSERT T-SQL statement.
Some people are fond of doing this as multiple single INSERT statements (INSERT ... SELECT ...; INSERT .... SELECT ...;). Me, I like using 1 INSERT clause and then a SELECT .... UNION ALL SELECT ... type of format.
If you had to choose between the two T-SQL options, which would you choose and why?
If I'm automating, I use the seperate insert for each, even if it may not be as optimal. I've had UNION ALL's choke at around 2000 records.
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
April 19, 2011 at 1:35 pm
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
I would love to attend that. Hopefully they will do the event in London next year when i'll be on a sql server contract. I'm currently working on Oracle so don't feel i'll benefit as much as I could.
April 19, 2011 at 2:07 pm
WayneS (4/19/2011)
Brandie, if I was using 2008, I'd use the INSERT Values(), (), () thing. If 2005, most likely the union all, if the # of rows wasn't too high.
Same here.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 25,816 through 25,830 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply