Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

VIEWS 3 Expand / Collapse
Author
Message
Posted Monday, March 19, 2012 8:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
Comments posted to this topic are about the item VIEWS 3

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1269316
Posted Monday, March 19, 2012 8:56 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 1:43 AM
Points: 1,291, Visits: 1,125
Thank you bitbucket. Nice and straight forward question.

--- Babu
Post #1269319
Posted Monday, March 19, 2012 11:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
Nice one, thanks. No room for error there.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1269341
Posted Tuesday, March 20, 2012 12:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 13,238, Visits: 11,012
According to CREATE VIEW (Transact-SQL):


When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.


Information that is stored in system tables also consumes space...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1269350
Posted Tuesday, March 20, 2012 2:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:57 AM
Points: 2,556, Visits: 2,416
baabhu (3/19/2012)
Thank you bitbucket. Nice and straight forward question.

--- Babu

+1
Thank you very much.
Post #1269388
Posted Tuesday, March 20, 2012 2:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, October 3, 2014 12:27 AM
Points: 2,442, Visits: 760
Koen Verbeeck (3/20/2012)
According to CREATE VIEW (Transact-SQL):


When a view is created, information about the view is storedin the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.


Information that is stored in system tables also consumes space...

Of course it does. You explained
minimal space required for the CREATE VIEW statement…
Post #1269391
Posted Tuesday, March 20, 2012 2:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:53 AM
Points: 13,238, Visits: 11,012
dawryn (3/20/2012)
Koen Verbeeck (3/20/2012)
According to CREATE VIEW (Transact-SQL):


When a view is created, information about the view is storedin the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.


Information that is stored in system tables also consumes space...

Of course it does. You explained
minimal space required for the CREATE VIEW statement…


That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also stored in other catalog views. Not just the CREATE statement.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1269403
Posted Tuesday, March 20, 2012 3:17 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:29 AM
Points: 900, Visits: 1,260
Nice question, got it right without having to look anything up. I must be slowly learning something.
Post #1269411
Posted Tuesday, March 20, 2012 3:24 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:37 AM
Points: 4,013, Visits: 5,306
Good back-to-basics question, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1269412
Posted Tuesday, March 20, 2012 3:31 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,777, Visits: 6,455
Koen Verbeeck (3/20/2012)That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also stored in other catalog views. Not just the CREATE statement.


+1

I chose the same "wrong" answer for the same reason. The question was explicit in excluding the CREATE, so it's a fair assumption that the other system tables are not excluded (or it should have said 'minimal space required for the system tables').
Post #1269416
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse