Login
Register
Tutorials
Forum
Career Development
Resources
Reviews
Jobs
Interview
Communities
Projects
Training
Silverlight Games
|
Bookmarks
|
New Members FAQ
|
Mentor
|
Code Converter
|
IT Companies
|
Peer Appraisal
|
Members
|
Revenue Sharing
|
Computer Jokes
|
New Posts
|
Social
|
Online Members
AHMED
More...
Resources
»
Code Snippets
»
SQL
How to find the page size of Sql Server 2005
Posted Date:
18-Jun-2010
Category:
SQL
Author:
Ultimaterengan
Member Level:
Gold
Points
: 2
How to find the page size of Sql Server 2005
How to find the page size of Sql Server 2005?
Abstract
Easily we can find the page size of sql server.By using the below query You will get the number of page in SQL Server.
SELECT low FROM master..spt_values WHERE number = 1 AND type = 'E'
The out put of the above query is
8192
Related Resources:
How to get Row Number with the result of SQL select query
How to get Last row (record) from a table
Sql join
Query : How to fetch comma separted column values
Use Alias Name in Select And Where Clause
How to pass textbox value to Sql Query?
Sort AlphaNumeric & Numeric Data
Information about database and its file sizes.
SQL Script To Get Table Wise No Of Rows
Read related articles:
Number of pages in SQL
SQL server page size
SQL query
Did you like this resource? Share it with your friends and show your love!
Tweet
Responses to "How to find the page size of Sql Server 2005"
No responses found. Be the first to respond...
Feedbacks
Post Comment:
Notify me by email when others post comments to this article.
Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
No HTML formatting and links to other web sites are allowed.
This is a strictly moderated site. Absolutely no spam allowed.
Name:
Sign In
to fill automatically.
Email:
(Will not be published, but
required
to validate comment)
Type the numbers and letters shown on the left.
Next Resource:
SQL Script to Concatenate column values
Previous Resource:
SQL Script To Get Table Wise No Of Rows
Return to Resources
Post New Resource
Category:
SQL
Post resources and
earn money
!
More Resources
SQL Script to Concatenate column values
STDisjoint(),STEndPoint(),STEnvelope(),STEquals() Function of Geometry Datatype
STConvexHull(),STCrosses(),STDifference() Function of Geometry Datatype
STBuffer(),STCentroid(),STContains() of Geometry datatype
Some Geometry Datatype Function
STIntersects() Funtion of Geometry Type
Popular Tags
Tag posting guidelines
Search Tags
How to find the page size of Sql Server 2005
.
Active Members
Today
Pawan Awasthi
(46)
naveensanagase...
(21)
Kapil
(13)
Last 7 Days
naveensanagase...
(224)
Pawan Awasthi
(190)
Naved Hasan ...
(189)
more...
Awards & Gifts
Email subscription
.NET Jobs
.NET Articles
.NET Forums
Articles Rss Feeds
Forum Rss Feeds
Talk to Webmaster Tony John