May 11, 2012 at 2:10 pm
Lynn Pettis (5/11/2012)
TGIF
Another four hours to go, here on the Wet Coast...
May 11, 2012 at 2:44 pm
Happy Friday.
I fly to Vegas this weekend to visit some family for Mother's Day. Anyone else in town that might like to try to grab a beer or three Sat night? I'll be staying at the Texas.
Post here or something and we'll work it out when I can get a chance to hop online if you don't get me before the flight leaves. I'd say hit my twitter but my phone doesn't do twitter. 😉 Apparently they don't make twitter for Palm OS... 😀
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
May 11, 2012 at 3:46 pm
GilaMonster (5/11/2012)
Aaah, nerves. The wait is killing me...
Must be... London?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 11, 2012 at 4:08 pm
WayneS (5/11/2012)
GilaMonster (5/11/2012)
Aaah, nerves. The wait is killing me...Must be... London?
No.
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 11, 2012 at 4:23 pm
GilaMonster (5/11/2012)
WayneS (5/11/2012)
GilaMonster (5/11/2012)
Aaah, nerves. The wait is killing me...Must be... London?
No.
First Date then! Good luck!
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
May 12, 2012 at 2:10 am
Evil Kraig F (5/11/2012)
GilaMonster (5/11/2012)
WayneS (5/11/2012)
GilaMonster (5/11/2012)
Aaah, nerves. The wait is killing me...Must be... London?
No.
First Date then! Good luck!
??!!?? err....?????
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 12, 2012 at 2:17 am
Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or anything else critical and handle them please?
Twitter will probably be the easiest way of getting hold of me if anyone needs.
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 13, 2012 at 7:33 pm
GilaMonster (5/12/2012)
Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or anything else critical and handle them please?Twitter will probably be the easiest way of getting hold of me if anyone needs.
Enjoy London and IE2.
May 13, 2012 at 9:18 pm
Sean Lange (5/11/2012)
Sometime in the somewhat recent past somebody shared a story about a company that went belly up due to their triggers not supporting multiple rows. I brought this up in a recent thread and Dwain was interested to know more about it. Apparently he recently fixed all the triggers at his company because none of them supported multiple row activity. Does anybody remember much about that story or who it was from? If so, care to share the story again?
Sean - thanks for trying. Actually it wasn't all triggers at my company, just all triggers in an app my company supports for another. And possibly not all at that (but most).
I'd seriously be interested in any kind of article where single use triggers caused a company financial harm of any sort.
Oh and BTW. I've been using the below terminology. If anyone knows of different, more widely accepted terminology, I'd appreciate knowing what that is.
Single use trigger - A trigger that operates only on a single (i.e., the last) record INSERTed, UPDATEd or DELETEd.
Bulk trigger - A trigger that operates for all records INSERTed, UPDATEd or DELETEd.
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
May 14, 2012 at 4:16 am
dwain.c (5/13/2012)
Oh and BTW. I've been using the below terminology. If anyone knows of different, more widely accepted terminology, I'd appreciate knowing what that is.Single use trigger - A trigger that operates only on a single (i.e., the last) record INSERTed, UPDATEd or DELETEd.
Bulk trigger - A trigger that operates for all records INSERTed, UPDATEd or DELETEd.
I would use the terms Single Row (or record) Trigger and Set-Based Trigger if you want no misunderstandings.
May 14, 2012 at 4:38 am
Brandie Tarvin (5/14/2012)
dwain.c (5/13/2012)
Oh and BTW. I've been using the below terminology. If anyone knows of different, more widely accepted terminology, I'd appreciate knowing what that is.Single use trigger - A trigger that operates only on a single (i.e., the last) record INSERTed, UPDATEd or DELETEd.
Bulk trigger - A trigger that operates for all records INSERTed, UPDATEd or DELETEd.
I would use the terms Single Row (or record) Trigger and Set-Based Trigger if you want no misunderstandings.
I'd likely use the terms "improperly written single row trigger" and "properly written multi-row-capable trigger". Or, "broken" and "properly written" for short. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
May 14, 2012 at 4:47 am
"Broken" works. @=)
May 14, 2012 at 7:03 am
GilaMonster (5/12/2012)
Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or anything else critical and handle them please?Twitter will probably be the easiest way of getting hold of me if anyone needs.
Happy travels Gail, sorry we can't give you better weather on this trip.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
May 14, 2012 at 7:06 am
Random topic choice:
Anyone know of any good internet articles on the history of the Greek Chorus? I can't seem to find my theatre history books at home and it's driving me nuts.
May 14, 2012 at 7:08 am
RBarryYoung (5/10/2012)
Koen Verbeeck (5/10/2012)
Stefan Krzywicki (5/10/2012)
Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through a list of the Oracle tables obtained with a query against all_tables. It is slow, it is tedious, but it is more reliable. I worked out the permissions, needed to either encrypt the package with a password instead of a user key or set up a proxy, neither of which I'd done before, so at least I'm learning new things!
Never encrypt with user key in SSIS, it only gives troubles ahead, as you probably figured out by now 😀
My experience has been that "Don't Save Sensitive.." and relying on Trusted Connections is by far the easiest way to go.
Wow, the long lost R. Barry Young, returns. Good to hear from you again.
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
Viewing 15 posts - 36,061 through 36,075 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply