Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.
SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video
What is the quickest way of importing CSV file data into a SQL Server table? This SQL in Sixty Seconds video shows it: create a table, BULK INSERT, verify.
Building a Reference You Will Actually Use Again
Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.
SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video
SELECT * pulls extra columns, hurts plans and makes debugging hard. This sixty second video shows two tricks to replace SELECT * with column names.
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
SSMS comes with many built-in performance and activity reports. This sixty second video shows where to find the Standard Reports and how to run them.
SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video
Need sample data to try new SQL Server features safely? This SQL in Sixty Seconds video shows how to install the AdventureWorks sample database.
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video
Vinod Kumar is back with T-SQL constructs in SQL in Sixty Seconds #009, showing how .NET developers can use familiar syntax like *= and += in T-SQL.