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
Jobs @ SQLAuthority.com
Reference : Pinal Dave (https://blog.sqlauthority.com)
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
I am amazed with it. It is a good thing for my research. Thanks
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.
Should alias names be preceded by AS?
Please suggest me on the above question.
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
@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.