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.

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 (http://blog.sqlauthority.com)

About these ads

6 thoughts on “SQL SERVER – Top Five Articles of Year 2008

  1. 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.

  2. 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

  3. @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.

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