Comprehensive Database Performance Health Check | Testimonials

SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case frontimage1

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.

SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case frontimage2

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.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
, , , , ,
1 Comment
The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components: Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML Analysis Services Integration Services Notification Services Reporting Services Replication The samples databases downloads include…
Read More

SQL SERVER – FIX : Error 15023: User already exists in current database.

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
, , , , , , , ,
129 Comments
Error 15023: User already exists in current database. 1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login 'Report' GO Run following T-SQL Query in Query Analyzer…
Read More

SQL SERVER – Primary Key Constraints and Unique Key Constraints

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
, , , , , , , , ,
97 Comments
Primary Key: Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. Primary Key does not allow Nulls. Create table with Primary Key: CREATE TABLE Authors ( AuthorID INT NOT NULL PRIMARY KEY, Name VARCHAR(100) NOT NULL ) GO…
Read More

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
, ,
102 Comments
Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source. Run Following T-SQL statement in query analyzer: SELECT dbo.udf_TitleCase('This function will convert this string to title case!') The…
Read More

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 35 Pluralsight courses and has written over 5400 articles on database technology on his blog at a https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

For any SQL Server Performance Tuning Issue send an email 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.

Exclusive Newsletter

Quest
Melissa

Menu