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: Today @ 9:28 AM
Points: 5,573, Visits: 24,808
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: Tuesday, July 22, 2014 1:19 AM
Points: 1,282, Visits: 1,114
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: 2 days ago @ 5:47 AM
Points: 1,904, Visits: 2,827
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:02 PM
Points: 13,334, Visits: 10,201
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:50 AM
Points: 2,466, Visits: 2,343
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: Thursday, July 10, 2014 1:48 AM
Points: 2,359, Visits: 730
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:02 PM
Points: 13,334, Visits: 10,201
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: Today @ 9:19 AM
Points: 887, Visits: 1,226
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:38 PM
Points: 3,864, Visits: 5,012
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 @ 10:28 AM
Points: 1,714, Visits: 6,256
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