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.
Find Your IP
Quickly find your IP.




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.