• 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 - Enable xp_cmdshell using sp_configure 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 - Enable xp_cmdshell using sp_configure elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

SQL SERVER – Restrictions of Views – T SQL View Limitations

UPDATE: (5/15/2007) Thank you Ben Taylor for correcting errors and incorrect information from this post. He is Database Architect and writes Database Articles at www.sswug.org.

I have been coding as T-SQL for many years. I never have to use view ever in my career. I do not see in my near future I am using Views. I am able to achieve same database architecture goal using either using Third Normal tables, Replications or other database design work around.SQL Views have many many restrictions. There are few listed below. I love T-SQL but I do not like using Views.

Read More

SQL SERVER – Good, Better and Best Programming Techniques

A week ago, I was invited to meeting of programmers. Subject of meeting was “Good, Better and Best Programming Techniques”. I had made small note before I went to meeting, so if I have to talk about or discuss SQL Server it can come handy. Well, I did not get…
Read More

SQL SERVER – Difference Between Unique Index vs Unique Constraint

Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both. Add Unique Constraint ALTER TABLE dbo.<tablename> ADD CONSTRAINT <namingconventionconstraint> UNIQUE NONCLUSTERED ( <columnname> ) ON [PRIMARY] Add Unique Index CREATE UNIQUE NONCLUSTERED INDEX <namingconventionconstraint> ON dbo.<tablename> ( <columnname> ) ON [PRIMARY] There…
Read More
Menu