Cannot find template file for new query means SSMS lost a small local file. Where it lives, how to restore it, and what to check next.
SQL SERVER – Find All The User Defined Functions (UDF) in a Database
A very simple script that lists all the User Defined Functions in a database, with schema name and type, by reading sys.objects in SQL Server.
SQL SERVER – Find Great Job with Great Pay
Where can you find a Great Job with Great Pay in SQL Server? I set up a job board where companies list jobs and good candidates find the right one.
SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
Takayuki Hoshino’s top 10 best practices for SQL Server Maintenance for SAP: daily full backups, frequent log backups, DBCC CHECKDB, statistics and index care.
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.
Documenting a Database With Extended Properties
Keep extended properties beside your SQL Server schema, maintain table and column descriptions, and query a useful data dictionary.
SSIS or T-SQL for a Simple Load
SSIS or T-SQL for a simple load depends on sources, transformations, logging, and operations; learn when a stored procedure is enough.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
A collection of funny quotes about computers and programming from Rich Cook, Dennis Ritchie, Isaac Asimov and others. A little SQL humor for your day.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
A simple Table Partitioning tutorial for SQL Server 2005 that shows, step by step, how to horizontally partition a database table across two filegroups.