• 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 - Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns 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 - Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

SQL SERVER – 64 bit Architecture and White Paper

In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here.…
Read More

SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

Some errors never got old. I have seen many new DBA or Developers struggling with this errors. Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection. Fix/Solution/Workaround: Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”…
Read More

SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns

Error Received: Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns SQL Server 2000 supports table with maximum 1024 columns. This errors happens when we try to create table with 1024 columns or try to add columns to table which exceeds more than 1024. Fix/Solution/WorkAround:…
Read More
Menu