View Single Post

   
  #9 (permalink)  
Old 02-29-2008, 07:07 PM
Erland Sommarskog
 
Posts: n/a
Default Re: select * in views

Peter (someone@someplace.com) writes:
> Is there an extra performance overhead now in SQL Server 2000/2005 when I
> use select * in views instead of naming each column of the table?


No.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Reply With Quote