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

master.dbo.spt_values means????????? Expand / Collapse
Author
Message
Posted Thursday, June 23, 2005 3:30 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 11:03 AM
Points: 243, Visits: 6

Hello friends!!

Can anybody tell me 'The meaning of this output'

I saw 6 columns , anybody tell me what they columns indicate


SELECT *
from master.dbo.spt_values

T.I.A

Shashank






Regards,

Papillon
Post #193376
Posted Thursday, June 23, 2005 3:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285

This is an internal helper table used by SQL Server.



--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #193379
Posted Thursday, June 23, 2005 6:18 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 21,385, Visits: 9,603
Care to enumerate what they all mean??
Post #193423
Posted Thursday, June 23, 2005 6:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
It's not worth talking about. This table is a design nightmare of a "super" lookup table.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #193427
Posted Thursday, June 23, 2005 6:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 21,385, Visits: 9,603
Hence .
Post #193443
Posted Thursday, June 23, 2005 7:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:59 AM
Points: 301, Visits: 611
These values are your server run time configuration.  See sp_configure in books on line.  Secondly this information is pretty well documented in most sql admin books.  One hand book you might want to get is "SQL Server 2000 Administrator's Pocket Consultant". 


Post #193456
Posted Sunday, June 26, 2005 3:18 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 29, 2005 3:36 PM
Points: 57, Visits: 1
I absolutely agree with Frank. I had to write a script recently to collect information on all the properties of all the Linked Servers on a given server. To collect the information on the 'Server Options' tab, I had to go to this spt_values table to get the description. crazy table


Post #194166
Posted Monday, June 27, 2005 6:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 21,385, Visits: 9,603
Maybe we should make a little life story on this one, and add it up against the super lookup tables articles .
Post #194259
Posted Tuesday, June 12, 2012 11:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 1, 2013 1:47 PM
Points: 167, Visits: 164
SELECT TOP 25 A.name,(SELECT rows FROM dbo.sysindexes s WITH (NOLOCK)  
WHERE s.indid < 2 AND s.id = A.ID )AS [Row count],SpaceUsedMB from
(SELECT SO.NAME,SO.ID,
CONVERT(numeric(15,2),(((CONVERT(numeric(15,2),SUM(i.reserved)) * (SELECT low
FROM master.dbo.spt_values WITH (NOLOCK) WHERE number = 1 AND type = 'E')) / 1024.)/1024.)) SpaceUsedMB
FROM dbo.sysindexes i WITH (NOLOCK) INNER JOIN dbo.sysobjects so WITH (NOLOCK)
ON i.id = so.id AND so.type IN ('U')
WHERE indid IN (0, 1, 255)
GROUP BY SO.NAME,SO.ID)
AS A
ORDER BY SpaceUsedMB DESC

Just one of the many uses of spt_values
Post #1314622
Posted Monday, December 10, 2012 8:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:06 PM
Points: 8, Visits: 31
Thanks, this is useful!
Post #1394863
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse