May 30, 2012 at 2:01 pm
GilaMonster (5/30/2012)
Too snarky?http://www.sqlservercentral.com/Forums/Topic1306465-334-1.aspx
Hard to say because the content of the question(s). I'd have a hard time not coming across as snarky if I posted any answers on that thread.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 30, 2012 at 2:10 pm
Jack Corbett (5/30/2012)
GilaMonster (5/30/2012)
Too snarky?http://www.sqlservercentral.com/Forums/Topic1306465-334-1.aspx
Hard to say because the content of the question(s). I'd have a hard time not coming across as snarky if I posted any answers on that thread.
I think I should quit that thread while I'm behind...
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
May 30, 2012 at 2:35 pm
Revenant (5/30/2012)
Koen Verbeeck (5/30/2012)
dwain.c (5/30/2012)
Maybe we should start a new thread for oenophiles.We could call it the wine cooler thread!:-)
As long as there will also be an equivalent beer thread 🙂
I will follow both. 🙂
Et voila, the beer cooler thread is a fact!
http://www.sqlservercentral.com/Forums/Topic1308613-61-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 30, 2012 at 2:37 pm
Revenant (5/30/2012)
If it was easy, our jobs would be much less stable.edit: BTW, I like your pretty thorough replies re how to reuse SSIS package.
Thanks. I was sure hoping my browser wouldn't crash when hitting the post button, because I wouldn't like to type it all out again. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 31, 2012 at 12:45 pm
mtillman-921105 (5/29/2012)
Jack Corbett (5/29/2012)
For those not on tiwtter, just signed the papers for my new house. Went from no debt to hundreds of thousands, but in the long run it'll be great!Any of you New England folks are welcome to make a trip to NH this Saturday to help us move. For the next month I have 2 houses so I can even put up some travellers 😀
Congratulations Mr. Corbett.
We just bought a home ourselves in the Denver (CO) area. We are apartment dwellers no-more.
Congrats to both of you. Where are you, Mr. Tillman?
May 31, 2012 at 1:15 pm
So much fun when moving hundreds of Oracle tables to SQL Server that Oracle alphabetizes as
X, Y, Z, _
and SQL Server alphabetizes as
_, A, B, C
When every table and column name is ALL CAPS and EVERYONE_LOVES_USDERSCORES_EVERYWHERE it becomes a real PITA to keep track of everything.
--------------------------------------
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
May 31, 2012 at 1:18 pm
Steve Jones - SSC Editor (5/31/2012)
mtillman-921105 (5/29/2012)
Jack Corbett (5/29/2012)
For those not on tiwtter, just signed the papers for my new house. Went from no debt to hundreds of thousands, but in the long run it'll be great!Any of you New England folks are welcome to make a trip to NH this Saturday to help us move. For the next month I have 2 houses so I can even put up some travellers 😀
Congratulations Mr. Corbett.
We just bought a home ourselves in the Denver (CO) area. We are apartment dwellers no-more.
Congrats to both of you. Where are you, Mr. Tillman?
Thanks Steve. We bought a home just north of Denver. 'Still trying to unpack boxes (again!). By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?
Anyway, Colorado is so much better than where we were living. It's dry, but relatively cool here for instance.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
May 31, 2012 at 1:20 pm
Stefan Krzywicki (5/31/2012)
So much fun when moving hundreds of Oracle tables to SQL Server that Oracle alphabetizes asX, Y, Z, _
and SQL Server alphabetizes as
_, A, B, C
When every table and column name is ALL CAPS and EVERYONE_LOVES_USDERSCORES_EVERYWHERE it becomes a real PITA to keep track of everything.
Even more fun when Oracle caps you at 30 characters.
May 31, 2012 at 1:22 pm
Lynn Pettis (5/31/2012)
Stefan Krzywicki (5/31/2012)
So much fun when moving hundreds of Oracle tables to SQL Server that Oracle alphabetizes asX, Y, Z, _
and SQL Server alphabetizes as
_, A, B, C
When every table and column name is ALL CAPS and EVERYONE_LOVES_USDERSCORES_EVERYWHERE it becomes a real PITA to keep track of everything.
Even more fun when Oracle caps you at 30 characters.
I'm actually kind of happy about that so I don't end up with things in the wrong order because characters starting at 100 are _STORE_ and _STORES_
I'm hoping that after I get everything to SQL Server I can re-write everything.
--------------------------------------
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
May 31, 2012 at 1:26 pm
Lynn Pettis (5/31/2012)
Stefan Krzywicki (5/31/2012)
So much fun when moving hundreds of Oracle tables to SQL Server that Oracle alphabetizes asX, Y, Z, _
and SQL Server alphabetizes as
_, A, B, C
When every table and column name is ALL CAPS and EVERYONE_LOVES_USDERSCORES_EVERYWHERE it becomes a real PITA to keep track of everything.
Even more fun when Oracle caps you at 30 characters.
Of course, now that you mention it, that's probably why there are table names like COM_PL_RPT_FMT_WTH_GRP_CST_EMP
totally readable, what are you talking about?
It is also fun that, likely because of the character limit, the use of underscores is sometimes partially abandoned.
--------------------------------------
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
May 31, 2012 at 1:53 pm
mtillman-921105 (5/31/2012)
Thanks Steve. We bought a home just north of Denver. 'Still trying to unpack boxes (again!). By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?Anyway, Colorado is so much better than where we were living. It's dry, but relatively cool here for instance.
Drink lots of water. Always. It's dry here for sure.
June 1, 2012 at 12:56 am
Calling all SSIS experts that may come to the water cooler for a drink!
I have posted an SSIS question in the SQL 2008 General forum and I'm not sure that's really the best place for it as there are other SSIS forums.
Just raising awareness. Thanks in advance for any help you can give me.
http://www.sqlservercentral.com/Forums/Topic1309462-391-1.aspx#bm1309505
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
June 1, 2012 at 1:20 am
dwain.c (6/1/2012)
Calling all SSIS experts that may come to the water cooler for a drink!I have posted an SSIS question in the SQL 2008 General forum and I'm not sure that's really the best place for it as there are other SSIS forums.
Just raising awareness. Thanks in advance for any help you can give me.
http://www.sqlservercentral.com/Forums/Topic1309462-391-1.aspx#bm1309505
Added my two cents.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 1, 2012 at 1:23 am
Koen Verbeeck (6/1/2012)
dwain.c (6/1/2012)
Calling all SSIS experts that may come to the water cooler for a drink!I have posted an SSIS question in the SQL 2008 General forum and I'm not sure that's really the best place for it as there are other SSIS forums.
Just raising awareness. Thanks in advance for any help you can give me.
http://www.sqlservercentral.com/Forums/Topic1309462-391-1.aspx#bm1309505
Added my two cents.
Yes. I saw that and thanks.
Perhaps I should post this to the beer cooler thread for maximum exposure.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
June 1, 2012 at 1:25 am
dwain.c (6/1/2012)
Perhaps I should post this to the beer cooler thread for maximum exposure.
Only if you add a picture of your favorite beer 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 36,346 through 36,360 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply