Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
create table Catch22(rowid int identity(1,1), data varchar(80)) GO insert into Catch22 select 'abc' insert into Catch22 select 'yyz' insert into Catch22 select 'pdq' insert into Catch22 select 'xyz' insert into Catch22 select 'cat' GO create view vCatch22 as select top 100 rowid, data from Catch22 order by data GO select * from vCatch22 GO ------ The above works as expected, but using top PERCENT below does not ... why? ------- alter view vCatch22 as select top 100 PERCENT rowid, data from Catch22 order by data GO select * from vCatch22 GO -- create unique clustered index x1 on Catch22(data,rowid) -- this works, but is not applicable in my real scenario drop view vCatch22 truncate table Catch22 drop table Catch22 --
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|index related performance counter for SQL server DB||11||37|
|Need help in debugging a UDF results||7||71|
|partitioning database after decade growth||8||79|
|SQL Need to calculate age from DOB, no stored procedures or functions allowed||10||87|
Join the community of 500,000 technology professionals and ask your questions.