Problem during inserting row in a table ( sql server 2005)

Question

Post reply

Problem during inserting row in a table ( sql server 2005)

Viewing 13 posts - 16 through 28 (of 28 total)

You must be logged in to reply to this topic. Login to reply

dsachu SSCrazy Points: 2242 More actions · Answer 1

dsachu

SSCrazy

Points: 2242

January 5, 2012 at 5:09 am

#1428915

expect answer from someone..kindly help me.

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 2

kumar.sachu08 (1/5/2012)
expect answer from someone..kindly help me.

Have you actually read any of the responses that have been given so far??

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

aldrin_mendiz Valued Member Points: 67 More actions · Answer 3

aldrin_mendiz

Valued Member

Points: 67

January 5, 2012 at 5:35 am

#1428935

Check whether u have created any clustered index.

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 4

kumar.sachu08 (1/5/2012)
I know i am fresher....and i am giving interview......i have only 1 years of experience.
then what should i do....when any interviewer asking like such type of question ?
Should i left the interview without attempting or i am not right person to know all the question answer ?
I am getting the problem to find out answer from itself. That's why I raging question.
If you understand fresher should not required such type of question answer then who will suggest interview don't ask such type of question with fresher.
Thanks.

That brings up a good question... is the job a "fresher" job or are they looking for someone with much more experience? If the latter is true, then you might not yet be the right person for the job.

To help you out a bit more on what to study for for a problem like this, you need to know a fair bit about the following...

Blocking and how to determine sources of blocking.

Indexes, especially UNIQUE indexes/PK's, and Fill Factors

Declared Referential Integrity (FK's)

Triggers

Indexed Views

I'd give you step-by-step except then you wouldn't learn well enough to actually do such a problem in real life. Other than real experience, only study and practice will leave you prepared. (buy a copy of the Developer's Edition and use it. It's not expensive.).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

>> "you also have a pot-wad of indexes"

Jeff, is "pot-wad" a new technical term coined by the Standing Exceptional DBA?? 😎

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 6

kumar.sachu08 (1/5/2012)
I know i am fresher....and i am giving interview......i have only 1 years of experience.
then what should i do....when any interviewer asking like such type of question ?
Should i left the interview without attempting or i am not right person to know all the question answer ?
I am getting the problem to find out answer from itself. That's why I raging question.
If you understand fresher should not required such type of question answer then who will suggest interview don't ask such type of question with fresher.
Thanks.

I have never seen DBA job openings for freshers. The minimum requirements in most of the DBA jobs are, 2-3 years of work experience in database (SQL Server or Oracle or any). But the interviewer always expect an candidate to answers *few* of DBA role questions. As Dave has already said, you can answer with NO and can always explain your *approach* to solve the issue (that’s what an interviewer is interested in).

If I may suggest, please focus on good points that Jeff (& many others) has raised. If you invest some of your time in understanding DBA routine jobs, it will help you in getting a good DBA jobs (I am afraid, not very soon).

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 7

TheSQLGuru (1/5/2012)
>> "you also have a pot-wad of indexes"
Jeff, is "pot-wad" a new technical term coined by the Standing Exceptional DBA?? 😎

Heh... my Grand Father gave me the term almost 45 years ago (although I've heard other people use the term and I'm sure they didn't know Grandpa). He used it in two different manners. One way comes from the two word's direct meanings: POT as in the winnings of a card game or lottery and WAD as in a "wad of money". The term came to mean "plentiful" for me, kind of like saying "more {fill in the blanks} than you can shake a stick at".

The other way he used it also came from two words, POT as in a "cooking pot" and WAD as in an unrecognizable pile of something and that meaning came to mean a "real mess of things". It seems that Grandma was making a pot of gravy one fine day. She added way too much flour, got distracted, and left it on the stove too long. It turned out to be a nearly solid lump of goo and Grandpa just couldn't help the irony in calling it a "pot-wad".

Depending on how many indexes you have and the effect it has on inserts, I suppose both meanings could be applicable here. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

DiegoPeña Right there with Babe Points: 749 More actions · Answer 8

Dave Ballantyne (1/4/2012)
TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.
If you are going for a DBA role , then you *should* know this.
If you don't , and your prospective employer needs your to, its the wrong job for you right now , sorry.

Man... do you know the word "HUMBLE"?

Did you notice that you didn't say anything helpful?

You could say something on the lines of "You could read this book or this post..." but no, you just have to point out that you he is not worthy of your knowledge.

... Anyway is good to see that there are other people who are willing to help.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 9

xaeru (1/6/2012)
Dave Ballantyne (1/4/2012)
TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.
If you are going for a DBA role , then you *should* know this.
If you don't , and your prospective employer needs your to, its the wrong job for you right now , sorry.
Man... do you know the word "HUMBLE"?
Did you notice that you didn't say anything helpful?
You could say something on the lines of "You could read this book or this post..." but no, you just have to point out that you he is not worthy of your knowledge.
... Anyway is good to see that there are other people who are willing to help.

1) Some people have earned the right to be a bit UNhumble. Dave is certainly one of those folks.

2) Like it or not, sometimes the BEST HELP you can give someone is to point out HUGE flaws in their knowledge, plans, etc., even to go so far as to point them in a different career direction or at least massively tone back their expectations. I have done the same numerous times in my almost 20 years in tech and felt it the best possible guidance I could give the person at the time.

3) You CANNOT POSSIBLY teach someone how to be a DBA from a set of forum posts. Nor can that person become a competent DBA by simply reading some blog posts, books, etc. It takes TIME IN THE TRENCHES, preferably under the mentorship of a good and experienced DBA.

4) I have lost track of the number of resumes I have reviewed and tech interviews I have performed for clients over the recent years that were from people who had absolutely no business applying for DBA positions. But they lost there jobs, or saw lower unemployment in technology fields or whatever and decided to do just what I said cannot be done: attempt to become a DBA "overnight" by reading a book, memorizing a certification test or two and passing that and applying for lots of DBA openings. Disaster!! It is hard enough finding a good DBA with 5 or even 8 years of experience because a) most people don't put much effort into improving their knowledge/skills and b) many DBAs simply do 5 years of the same "month" worth of work, as opposed to doing a variety of things both vertically and horizontally that will help them grow.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 10

Jeff Moden (1/5/2012)
TheSQLGuru (1/5/2012)
>> "you also have a pot-wad of indexes"
Jeff, is "pot-wad" a new technical term coined by the Standing Exceptional DBA?? 😎
Heh... my Grand Father gave me the term almost 45 years ago (although I've heard other people use the term and I'm sure they didn't know Grandpa). He used it in two different manners. One way comes from the two word's direct meanings: POT as in the winnings of a card game or lottery and WAD as in a "wad of money". The term came to mean "plentiful" for me, kind of like saying "more {fill in the blanks} than you can shake a stick at".
The other way he used it also came from two words, POT as in a "cooking pot" and WAD as in an unrecognizable pile of something and that meaning came to mean a "real mess of things". It seems that Grandma was making a pot of gravy one fine day. She added way too much flour, got distracted, and left it on the stove too long. It turned out to be a nearly solid lump of goo and Grandpa just couldn't help the irony in calling it a "pot-wad".
Depending on how many indexes you have and the effect it has on inserts, I suppose both meanings could be applicable here. 😀

Good story!! 🙂 Growing up primarily in the southeastern US I have used the term with the first meaning many times myself.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

DiegoPeña Right there with Babe Points: 749 More actions · Answer 11

TheSQLGuru (1/6/2012)
xaeru (1/6/2012)
Dave Ballantyne (1/4/2012)
TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.
If you are going for a DBA role , then you *should* know this.
If you don't , and your prospective employer needs your to, its the wrong job for you right now , sorry.
Man... do you know the word "HUMBLE"?
Did you notice that you didn't say anything helpful?
You could say something on the lines of "You could read this book or this post..." but no, you just have to point out that you he is not worthy of your knowledge.
... Anyway is good to see that there are other people who are willing to help.
1) Some people have earned the right to be a bit UNhumble. Dave is certainly one of those folks.
2) Like it or not, sometimes the BEST HELP you can give someone is to point out HUGE flaws in their knowledge, plans, etc., even to go so far as to point them in a different career direction or at least massively tone back their expectations. I have done the same numerous times in my almost 20 years in tech and felt it the best possible guidance I could give the person at the time.
3) You CANNOT POSSIBLY teach someone how to be a DBA from a set of forum posts. Nor can that person become a competent DBA by simply reading some blog posts, books, etc. It takes TIME IN THE TRENCHES, preferably under the mentorship of a good and experienced DBA.
4) I have lost track of the number of resumes I have reviewed and tech interviews I have performed for clients over the recent years that were from people who had absolutely no business applying for DBA positions. But they lost there jobs, or saw lower unemployment in technology fields or whatever and decided to do just what I said cannot be done: attempt to become a DBA "overnight" by reading a book, memorizing a certification test or two and passing that and applying for lots of DBA openings. Disaster!! It is hard enough finding a good DBA with 5 or even 8 years of experience because a) most people don't put much effort into improving their knowledge/skills and b) many DBAs simply do 5 years of the same "month" worth of work, as opposed to doing a variety of things both vertically and horizontally that will help them grow.

Well It just that I dont Believe in that "unhumble" thing... you never earn that. Been unhumble reflects on your life and not in a good way. Humbles Guru's have my respect.

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 12

xaeru (1/6/2012)
Dave Ballantyne (1/4/2012)
TBH , the problem solving skills that you would have to demonstrate would be an integral part of a DBA role.
If you are going for a DBA role , then you *should* know this.
If you don't , and your prospective employer needs your to, its the wrong job for you right now , sorry.
Man... do you know the word "HUMBLE"?
Did you notice that you didn't say anything helpful?
You could say something on the lines of "You could read this book or this post..." but no, you just have to point out that you he is not worthy of your knowledge.
... Anyway is good to see that there are other people who are willing to help.

I think over the course of this thread ive have been giving pretty good advice. The direction of it has changed, it started off as a " its running slow" to which i gave a few suggestions, there was no response from the OP. Then it turned into a ' help me ace this interview' thread , fair enough , i enjoy the interview process , but there is only a limited amount of knowledge you can learn about this (a DBA job) much of it has to be experienced. There is no , how to be a great DBA book. All i expressed was an opinion that the poster should be honest and upfront about his present skillset.

Anyway the poster only wanted Gails opinion , so im guessing mine doesnt count 🙂

Clear Sky SQL
My Blog[/url]

dsachu SSCrazy Points: 2242 More actions · Answer 13

Anyway the poster only wanted Gails opinion , so im guessing mine doesnt count 🙂

This is not true. I would like to learn with everyone. All are you important for me. if you all are getting any wrong sound from my side ........then i am very sorry for all of you.