SQLAuthority News – Tip of the Minute

Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website http://www.pinaldave.com contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip related to SQL Server.

Few of the tips from the page I am listing here.

  • Avoid unnecessary use of temporary tables.
  • Try to use constraints instead of triggers, rules, and defaults whenever possible.
  • SQL Server agent, allows you to schedule your own jobs and scripts.

If any reader who will send me all the tips which I have published on the page, I will send my user any product of choice from article SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product.

If you are going to collect the tips make sure to learn them, if you want more explanation about any tips please send me email or leave a comment and I will send you additional explanation.

Reference : Pinal Dave (http://www.SQLAuthority.com)

About these ads

3 thoughts on “SQLAuthority News – Tip of the Minute

  1. temp tables are used to store and process the data temporarely.
    The temp tables resides in the temp database and dropped whenever the server is restarted or removed intentionally.These tables are two types local and golbal, local temp tables exits only till the perticular session in which it is created,closed.(can be seen by the user who is created it start with @)

    Global temp tables exists till the last connection which is using this closed (prefexed with @@)(availbe to all the users)

    The temp tables reduce the burden on the server.
    eg. of using temp table is,when we want to remove the duplictes in exiting table which is having huge data fist place the existing data in the temp table ,remove duplicates from temp,truncate the original table,then load the distinct data from temp to original table

    Like

  2. Pingback: SQLAuthority News - 700 Articles and Author Updates Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s