SQL Scripts Archives - Page 282 of 318 - SQL Authority with Pinal Dave

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…

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 – 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 – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table

January 25, 2008

Pinal Dave

SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Server, Table Partitioning

I have received calls from my DBA friend who read my article SQL SERVER – 2005 – Introduction to Partitioning. He suggested that I should write a simple tutorial about how to horizontal partition database table. Here is a simple tutorial which explains how a table can be partitioned.

SQL SERVER – Get a Row Per File of a Database as Stored in the Master Database

January 21, 2008

Pinal Dave

SQL Tips and Tricks

Database, SQL Scripts, SQL Server, SQL System Table

Each database has a minimum of two files associated with the database. If a database has more than one filegroup it will have many files associated with one database. Following quick script will give you recordset per file of a database which is stored in master database.

SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet

January 14, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts

Just a day ago, I received following question: “I have large table more than 1M rows. I want to delete every row in my table. Everytime I ran DELETE statement, it times out and does not do it job. The data in table is useless and I do not need…