• An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
SQL SERVER - ReIndexing Database Tables and Update Statistics on Tables elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

Learn Now
Free Learning Videos
  • An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
Upcoming Events
SQL SERVER - ReIndexing Database Tables and Update Statistics on Tables elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

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

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.

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

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

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
Menu