SQL DBA Scripts for the Beginer to professional

• kiran.sharc

  Grasshopper

  Points: 17

  More actions

  April 15, 2015 at 6:48 pm

  #303036

  Hi Folks,

  I am new to SQL DBA world and looking for the SQL DBA scripts which frequently use. My apologies which I posted repeat query but I tried in google and other sites but no luck. Please redirect me whenever needed to get the information.

  Thanks

  Sharc

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  April 15, 2015 at 10:09 pm

  #1791236

  kiran.sharc (4/15/2015)

  ---

  Hi Folks,

  I am new to SQL DBA world and looking for the SQL DBA scripts which frequently use. My apologies which I posted repeat query but I tried in google and other sites but no luck. Please redirect me whenever needed to get the information.

  Thanks

  Sharc

  What kind of scripts are you looking for? Scripts to show how to do update, select, insert, delete? Or something else?

  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

• Jeff Moden

  SSC Guru

  Points: 1003864

  More actions

  April 15, 2015 at 10:19 pm

  #1791237

  kiran.sharc (4/15/2015)

  ---

  Hi Folks,

  I am new to SQL DBA world and looking for the SQL DBA scripts which frequently use. My apologies which I posted repeat query but I tried in google and other sites but no luck. Please redirect me whenever needed to get the information.

  Thanks

  Sharc

  Are you also new to T-SQL?

  --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)
  

• Grant Fritchey

  SSC Guru

  Points: 398694

  More actions

  April 16, 2015 at 6:00 am

  #1791291

  Do you mean maintenance scripts?

  If so, go here. You can see a number of different utilities for index maintenance, backups, and all sorts of other things.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning