SQL Server Performance

Question

Discussion in 'Getting Started' started by shubhada99, May 4, 2007.

  1. shubhada99 New Member

    1. I have 1 table "EmpTable" having 5 columns,2 indexes and 2 triggers.
    I want to add new column to "EmpTable" at 3 position. How I can add the new column?
    What is a flexible approch for this?
    Table Structure is as follow

    EmpTable -

    col1 col2 col3 col4 col5

    I want the structure as follow

    col1 col2 ColNEw col3 col4 col5


    2.What is the difference between roles and groups

    3. There are two set of user,running on two different set of procedures
    How to give a permissions to user on procedures
    Ex - Database DB1 having 100 procedures.
    user1 uses 50 procedures out of 100 and
    user2 uses remaining 50 procedures.

    4. Database DB1 having 100 procedures.
    Also there are 3 groups Gr1,Gr2 and Gr3
    Gr1 have 2 user uses 50 procedures out of 100 and
    Gr2 have 5 user uses remaining 50 procedures.

    But I want to add Gr1 & Gr2 to Gr3 so Gr3 can have the permission to all 100 Procedures.
    How I can add Gr1 & Gr2 to Gr3.

    5. How cache deadlocking is handle in stored procedures?

    6. concept of @@TranCount

    7. What is Nested transaction

    Plz give me some idea for all the above question.
  2. FrankKalis Moderator

    Please don't ask such many unrelated questions in one single thread! <br />It's better to start several threads instead.<br />And it is even "more" better to search the site before asking such broad and general questions. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />As for 1: There is no point in trying to add a column at a specific position. The only way is to use SSMS and that creates a new table behind the scenes. If you really need this position for whatever reason, create a view with the desired positioning and refer to the view.<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  3. Madhivanan Moderator

    <<
    Plz give me some idea for all the above question.
    >>

    Do Article search in this forum

    Madhivanan

    Failing to plan is Planning to fail
  4. Madhivanan Moderator

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83089

    Madhivanan

    Failing to plan is Planning to fail
  5. FrankKalis Moderator

  6. satya Moderator

    As suggested take your time to search through the forums and this site in addition to updated books online for SQL server, it will get you more information on these basic questions you need such information.

    Don't get us wrong that we suggest to review another set of publications, it is relevant and required when you need to know such an open based questions.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. MohammedU New Member

    Check Books Online for most of your answers....

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  8. DilliGrg Member

    Looks like really getting started in sql...<br />Also the headline/topic should be questions instead of <s>question</s>[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br /><br />Name<br />--------- <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">
  9. Asif Ali New Member

    at what step in a cursor where the query is execute?
  10. satya Moderator

    Asif
    For a better catchup why don't you start a fresh thread instead of posting in irrelevant post.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  11. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  12. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Madhivanan</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />There is a good article here on the site by mmarovic about situations where cursors are an alternative.<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  13. Madhivanan Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Madhivanan</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />There is a good article here on the site by mmarovic about situations where cursors are an alternative.<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes I agree. Thats why I specified the word <b>Rarely</b><br />Most newbies try to do the things using cursors only<br />If they are basically front end programmers, there is high chance that they want row-by-row operation for anything they want to do [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

Share This Page