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
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 Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Read More
SQL SERVER – Find Great Job with Great Pay
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.…
Read More
SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
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…
Read More
SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution
What to do when the query processor could not start the thread resources for parallel query execution, and why this error often clears itself.
SQLAuthority New – O’relly Style Book Cover for SQLAuthority
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. Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Read More
SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005
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…
Read More