Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified

February 7, 2008

Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts

Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server

February 6, 2008

Pinal Dave

SQL Tips and Tricks

CSV, SQL Scripts, SQL Utility

This is a very common request recently – How to import CSV file into SQL Server? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the solution in quick steps. CSV stands for Comma Separated Values, sometimes…

SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes

February 5, 2008

Pinal Dave

SQLAuthority News

Database, DBA, SQL Humor, SQL Server

I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.

SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE

February 4, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

WHILE statement sets a condition for the repeated execution of an SQL statement or statement block. Following is very simple example of WHILE Loop with BREAK and CONTINUE. USE AdventureWorks; GO DECLARE @Flag INT SET @Flag = 1 WHILE (@Flag < 10) BEGIN BEGIN PRINT @Flag SET @Flag = @Flag…

SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)

February 3, 2008

Pinal Dave

SQL

SQL Error Messages, SQL Server, Starting SQL

Just a day ago while playing with SQL Server I suddenly faced a new kind of error, which I have never seen before. This error happens when clicked on New Query in SQL Server Management Studio. Let us learn in this blog post how we will fix the error – cannot find template file for a new query.

SQL SERVER – Find All The User Defined Functions (UDF) in a Database

February 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Following script is very simple script which returns all the User Defined Functions for particular database. USE AdventureWorks; GO SELECT name AS function_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%'; GO Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Find Great Job with Great Pay

February 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Jobs

One question I have been asked consistently “Where can I find Great Job with Great Pay related to SQL Server?”. I have been aware of the fact that there are many jobs in market but finding one job which gives satisfaction in job as well has great salary are few.…