InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 02:52:02 GMT20http://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspxHi,Here you go:use tempdbselect name,(size*8)/1024 as Current_Size_MB,(max_size*8)/1024 as Total_Size_MB from sys.database_filesFri, 30 Dec 2011 02:49:09 GMTsaravanan.ayyasamyhttp://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspxAre those questions part of an interview?Fri, 30 Dec 2011 02:44:45 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspxHi I got the things about view. But what about the tempdb details. How can i identify whether the tempdb is full or not?Fri, 30 Dec 2011 02:22:15 GMTvaithi.saran846http://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspx[quote][b]vaithi.saran846 (12/29/2011)[/b][hr]Hi, what is the main advantage of view.? How view will help in performance. consider i have the some complex select query and i am running that in sql server and it is taking lot of time. In this case if i use view, how it will affect? whether the time taken by select query will reduce?regards,vaithilingam.k[/quote]If you're having problems with the performance of a complex query, why not post the query and the actual execution plan? Chances are, folks here will make suggestions to improve performance - and you are very likely to learn something useful too.Fri, 30 Dec 2011 02:19:23 GMTChrisM@homehttp://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspxView is mainly used for encapsulation, that is, hiding the complexity. In terms of performance, It will not help you a lot. For that, you need to go with " indexed views "Fri, 30 Dec 2011 01:24:22 GMTsaravanan.ayyasamyhttp://www.sqlservercentral.com/Forums/Topic1228176-1084-1.aspxHi, what is the main advantage of view.? How view will help in performance. consider i have the some complex select query and i am running that in sql server and it is taking lot of time. In this case if i use view, how it will affect? whether the time taken by select query will reduce?regards,vaithilingam.kThu, 29 Dec 2011 22:49:14 GMTvaithi.saran846