Blog Home Page - Page 813 of 829 - SQL Authority with Pinal Dave

May8

I am attending The 2007 Marketing Innovation Summit“, Las Vegas. It started on 5/6/2007 and will continue till 5/9/2007. Unica Corporation has arranged this conference. The MIS 2007 Agenda includes: Case studies and best practices Sessions focused on Relationship Marketing, Internet Marketing and Marketing Operations Hands on “how to” sessions…

May7

SQL SERVER – Top 10 Hidden Gems in SQL Server 2005

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Download

Top 10 Hidden Gems in SQL Server 2005 By Cihan Biyikoglu SQL Server 2005 has hundreds of new and improved components. Some of these improvements get a lot of the spotlight. However there is another set that are the hidden gems that help us improve performance, availability or greatly simplify…

May7

SQL SERVER – 2005/2000 Examples and Explanation for GOTO

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Utility

The GOTO statement causes the execution of the T-SQL batch to stop processing the following commands to GOTO and processing continues from the label where GOTO points. GOTO statement can be used anywhere within a procedure, batch, or function. GOTO can be nested as well. GOTO can be executed by…

May6

SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Following script will create common separate values (CSV) or common separate list from tables. convert list to table. Following script is written for SQL SERVER 2005. It will also work well with very big TEXT field. If you want to use this on SQL SERVER 2000 replace VARCHAR(MAX) with VARCHAR(8000)…

May6

SQL SERVER – UDF – Function to Convert List to Table

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Following Users Defined Functions will convert list to table. It also supports user defined delimiter. Following UDF is written for SQL SERVER 2005. It will also work well with very big TEXT field. If you want to use this on SQL SERVER 2000 replace VARCHAR(MAX) with VARCHAR(8000) or any other…

May5

SQL SERVER – 2005 Enable CLR using T-SQL script

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CLR, SQL Advanced Option, SQL Scripts, SQL Server Security

Before doing any .Net coding in SQL Server you must enable the CLR. In SQL Server 2005, the CLR is OFF by default. This is done in an effort to limit security vulnerabilities. Following is the script which will enable CLR. EXEC sp_CONFIGURE 'show advanced options' , '1'; GO RECONFIGURE;…

May5

SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Utility

Following user defined function returns number of weekdays between two dates specified. This function excludes the dates which are passed as input params. It excludes Saturday and Sunday as they are weekends. I always had this function with for reference but after some research I found original source website of…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas

SQL SERVER – Top 10 Hidden Gems in SQL Server 2005

SQL SERVER – 2005/2000 Examples and Explanation for GOTO

SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP

SQL SERVER – UDF – Function to Convert List to Table

SQL SERVER – 2005 Enable CLR using T-SQL script

SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates

Working with Hierarchies in SQL Server – A Comprehensive Course

MySQL’s Index Condition Pushdown (ICP) Optimization

SQL SERVER – Absolute Beginners 10 Queries

Dissecting BDD and TDD: An In-Depth Comparison

SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted

SQL SERVER – How to Move a Table into a Schema in T-SQL

SQL SERVER – Understanding MAX_DURATION in Index Creation