All Articles - SQL Authority with Pinal Dave

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

February 2, 2008

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.…

SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP

January 31, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Data Warehousing, Database

Top 10 Best Practices for SQL Server Maintenance for SAP By Takayuki Hoshino SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation. 1) Perform a full database backup daily 2) Perform…

SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution

January 30, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

ERROR : The query processor could not start the necessary thread resources for parallel query execution.

SQLAuthority New – O’relly Style Book Cover for SQLAuthority

January 29, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Humor

Yo Ming, Chin regular reader from Los Angeles, CA has sent me following image for SQLAuthority. Checkout O’reillymaker and create your own Book Cover. Reference : Pinal Dave (https://blog.sqlauthority.com) , O’reillymaker

SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005

January 28, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQLAuthority Book Review

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 (Paperback) by Jayaram Krishnaswamy (Author) Link to Amazon Short Summary: SQL Server Integration Services Using Visual Studio 2005 contains all the information and education needed for one to begin with SSIS. It covers all the basic concepts in depth…

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

January 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Humor

Following is the collection of some funny quotes regarding computers. Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Rich Cook. UNIX is basically a simple operating…

SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007

January 26, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

Microsoft SQL Server 2000 MSIT Comprehensive Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2000 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2000 MSIT Intermediate…

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 – 2005 – Introduction to Partitioning

January 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage

Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance. Tables are partition based on…