March 16, 2006 at 12:03 am
Hi Every one,
when i want to load tables into memory i use DBCC PINTABLE , but what can i do when i want to load VIEWS into memory the command DBCC PINTABLE raise error when trying to invoke views.?
any help pls..
Hoodi
March 17, 2006 at 3:17 am
whilst I think pinning tables is a bad idea - if a table is used frequently it will be in cache anyway - you can't pin a view as it's not a physical object. You could pin the underlying tables.
You might find adding more ram would be a better move than pinning tables which could adversely affect performance.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 17, 2006 at 8:25 am
Have a look at "indexed views" header , "view indexes" topic in the BOL. That may either help solve your problem, or at least help explain why you can't pin a view.
jg
March 17, 2006 at 9:47 am
FYI DBCC PINTABLE is not supported in SQL 2005
March 17, 2006 at 9:54 am
cool ! never liked pin table anyway < grin >
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 17, 2006 at 11:22 pm
Thanx everybody, i knew my mistake of understanding. Thanx for all efforts.
Hoodi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy