tag:blogger.com,1999:blog-16771259.post116468094338321523..comments2024-03-07T03:02:45.934-08:00Comments on SQL Server Code,Tips and Tricks, Performance Tuning: Do You Use Partitioned Views Or Indexed Views In SQL Server 2000Unknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-16771259.post-1164714778084482422006-11-28T03:52:00.000-08:002006-11-28T03:52:00.000-08:00Mladen,Thanks for your input. Our DB is not a VLDB...Mladen,<BR/><BR/>Thanks for your input. Our DB is not a VLDB but it is well over 100GB. I think create function is probably also something that I would have to look up however I usually copy an old function change the name, variables and voila I am done<BR/><BR/>DenisDenishttps://www.blogger.com/profile/13745938552201273794noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-1164714583699300392006-11-28T03:49:00.000-08:002006-11-28T03:49:00.000-08:00Adam, thanks I agree with you. The only reason I a...Adam, <BR/><BR/>thanks I agree with you. The only reason I asked for partitioned views/horizontal partitioning is because we are using that. There is no point in asking candidates for some obscure things that are not in use anyway<BR/><BR/>DenisDenishttps://www.blogger.com/profile/13745938552201273794noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-1164710576038414432006-11-28T02:42:00.000-08:002006-11-28T02:42:00.000-08:00I agree with Adam.But Indexes views and partitione...I agree with Adam.<BR/>But Indexes views and partitioned views are used best with very large tables. and how many databases have a table with millions and millions of rows?<BR/><BR/>I haven't seen a db larger than 10 gb.<BR/><BR/>So I'm not surprised about your findins.<BR/>However knowing what they're for and how to write them are 2 different things.<BR/><BR/>I've written a lof of sql functions and i still have to go to BOL to look up the create function syntax. :))<BR/><BR/>So yes the candidates should know about them and what they're for (no excuse there) but i'd wouldn't be too harsh on that one.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16771259.post-1164696914012658812006-11-27T22:55:00.000-08:002006-11-27T22:55:00.000-08:00I think it's a perfectly acceptable question to as...I think it's a perfectly acceptable question to ask a candidate. Personally, I didn't use indexed views much in 2000 (but I did from time to time), and I can't remember ever using a partitioned view. But I knew exactly what they were and how to create them. And in 2005 projects I've been using indexed views a lot more -- performance is much improved... so candidates SHOULD know about them, IMO.Anonymousnoreply@blogger.com