SQL SERVER – Top Five Articles of Year 2008

Year 2008 was great year for me. I got plenty of request from readers asking for Top 10 or Top 5 articles of the year 2008. I am including Top 5 Articles of Year 2008 in two different categories. First is my blog SQLAuthority.com and another one is my home page pinaldave.com

TOP 5 Articles at SQLAuthority.com

This section has six links as very first link is repeated again in top 5 pages at pinaldave.com

SQL SERVER – 2008 – Interview Questions and Answers Complete List Download
Most popular and most visited page. Very first and compilation of SQL Server Interview Question and Answers.

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
Insert multiple records using SELECT statement.

SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Insert multiple records using UNION clause.

Solarwinds

SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
This is very common task among DBA and having this script handy saves some good time and work.

SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
Bulk inserting data from CSV file to SQL Server database is now simplified with this article.

SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
Easiest way to get date time in SQL Server

TOP 5 Pages at pinaldave.com

SQL Server 2008 Interview Questions and Answers
Most popular and most visited page. Very first and compilation of SQL Server Interview Question and Answers.

Best SQL Server Downloads List
Second Most popular and most visited page. This page is compiles all the SQL Server related downloads.

SQLAuthority.com – Frequently Used Scripts
Keeping this scripts handy helps to resolve the many problems quickly.

Résumé
Pinal Dave – SQL Server MVP’s Resume.

About Me
Pinal Dave

Other Popular Links

Search @ SQLAuthority.com

Jobs @ SQLAuthority.com

Reference : Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
,
Previous Post
SQLAuthority News – Security White Papers
Next Post
SQLAuthority News – Humor – Favorite Website – Funny Image

Related Posts

6 Comments. Leave new

  • Thanks for the good work you have been doing through 2008.

    I am just a new reader, browsing a lot around.

    Keep up the Great work

    Reply
  • I am amazed with it. It is a good thing for my research. Thanks

    Reply
  • Dear sir,
    Greetings. The Information you provided are valuable. They are reliable and very helpful for our carrier.
    But please do post some practical exercises which could be solved sir.
    This would definitely help the upcoming developers.

    Thank You.

    Reply
  • Should alias names be preceded by AS?

    Please suggest me on the above question.

    Reply
  • select * from [112.137.162.205].[CCRSVTEAM]..tbl_SvDetails

    OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName=’112.137.162.205′, TableName='”CCRSVTEAM”.”tbl_SvDetails”‘].
    Msg 7314, Level 16, State 1, Line 1
    OLE DB provider ‘112.137.162.205’ does not contain table ‘”CCRSVTEAM”.”tbl_SvDetails”‘. The table either does not exist or the current user does not have permissions on that table.

    pls help me
    thanks in advance

    Rajesh

    Reply
  • Imran Mohammed
    March 10, 2010 10:58 am

    @Rajesh,

    When ever you work with linked servers, make sure you give full four-part name without any short cuts.

    In your script you are not passing the name of owner object. (I can see double dots, which holds good for internal to a server but not for linked servers as far I understand)

    Four Part Name: Servername.Database.owner.objectname

    Did you name your linked server as: [112.137.162.205] ???

    ~ IM.

    Reply

Leave a Reply

Menu