August 5, 2010 at 12:21 pm
Jack Corbett (8/5/2010)
Off the technical and metric time topic (I love non-metric cause I'm an American :-D). Just had my PASS NomCom interview. Hard to tell how it went because it's on the phone so you don't get feedback you get in person.
Phone interviews are difficult to gauge without that visual feedback. Sometimes that is good and sometimes that is bad.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 5, 2010 at 12:34 pm
This OP wonders why he has performance issue when inserting data.
-Roy
August 5, 2010 at 12:47 pm
Funny. I didn't chime in on that one, but I have heard people claim that indexing every column was the way to go because "it keeps the indexes small" and "SQL can put together all the data from the indexes quicker". Poor guy either inherited that db or built it based on something someone said they had heard once.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2010 at 1:04 pm
Roy Ernest (8/5/2010)
This OP wonders why he has performance issue when inserting data.
I think Jeff, Gail, and Grant covered that one pretty well.
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
August 5, 2010 at 1:08 pm
Paul White NZ (8/5/2010)
Chris Morris-439714 (8/5/2010)
BUSHY PLANS!! Thank you, Paul. Time to give that another read.:laugh: :laugh: :laugh: :laugh: :laugh:
Isn't associative memory wonderful?
Stick or branch join...bushy plans...funny!
Paul
Made me think of the MIDDLE JOIN question that showed up in the QOD once:SELECT *
FROM dbo.Customers
MIDDLE JOIN dbo.Employees ON CustomerID = EmployeeID
December 13, 2007 if you want to go look it up, one of my favorites. 😀
Chad
August 5, 2010 at 1:11 pm
Roy Ernest (8/5/2010)
This OP wonders why he has performance issue when inserting data.
I once inherited a program (VB6) where the original programmer had 7 or 8 or 9 indexes on every table in an Access database. If that wasn't bad enough, he re-created the indexes every time someone opened the program. Fortunately, only one person could open the database at a time, but it still took 10 to 15 minutes just to open the damn thing, every single time.
--------------------------------------
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
August 5, 2010 at 1:31 pm
Stefan Krzywicki (8/5/2010)
I once inherited a program (VB6) where the original programmer had 7 or 8 or 9 indexes on every table in an Access database. If that wasn't bad enough, he re-created the indexes every time someone opened the program. Fortunately, only one person could open the database at a time, but it still took 10 to 15 minutes just to open the damn thing, every single time.
AHHHHHH! You said a swear word!!! Access.
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
August 5, 2010 at 1:35 pm
Jack Corbett (8/5/2010)
Stefan Krzywicki (8/5/2010)
I once inherited a program (VB6) where the original programmer had 7 or 8 or 9 indexes on every table in an Access database. If that wasn't bad enough, he re-created the indexes every time someone opened the program. Fortunately, only one person could open the database at a time, but it still took 10 to 15 minutes just to open the damn thing, every single time.
AHHHHHH! You said a swear word!!! Access.
I got them to switch over to SQL Server pretty quickly when I showed them the kind of performance benefits they'd get with the databases they had that were over 2 gig. As it was, they had 1 database per company per month.
--------------------------------------
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
August 5, 2010 at 4:50 pm
Alvin Ramard (8/5/2010)
The Dixie Flatline (8/5/2010)
Wow, a nice technical discussion on The Thread.
Who'd have thought?
SACRILEGE!! HERESY!! CURSORS!! :w00t::w00t:
Doesn't Rule #9 (not sure about the number) say something about no technical discussions in the Thread? 😉
Actually, I think technical discussions amongst "co-workers" at the water cooler are permitted. What isn't permitted is answering OP questions, those belong in the appropriate thread.
I mean, really, how many times have you held hallway meetings with real co-workers that were technical in nature? I have done it, and it usually is quite beneficial.
August 5, 2010 at 4:54 pm
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
August 5, 2010 at 4:56 pm
Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
Good luck!! And don't worry, you should make it no problem!
August 5, 2010 at 4:57 pm
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!
August 5, 2010 at 5:01 pm
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
Have a nice, quiet, last day and best of luck in the new gig.
August 5, 2010 at 5:16 pm
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
Good Luck in them letting you actually leave! :crying:
Seriously, best of luck in your new position.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2010 at 6:03 pm
Lynn Pettis (8/5/2010)
Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.Good luck!! And don't worry, you should make it no problem!
I second that!
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 - 17,161 through 17,175 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply