|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, May 10, 2007 3:53 AM
Points: 243,
Visits: 1
|
|
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
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Friday, May 17, 2013 8:10 AM
Points: 5,955,
Visits: 272
|
|
|
|
|
|
SSC-Insane
         
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
|
|
Care to enumerate what they all mean??   
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Friday, May 17, 2013 8:10 AM
Points: 5,955,
Visits: 272
|
|
|
|
|
|
SSC-Insane
         
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
|
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:56 AM
Points: 282,
Visits: 402
|
|
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".
|
|
|
|
|
Valued 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
|
|
|
|
|
SSC-Insane
         
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
|
|
Maybe we should make a little life story on this one, and add it up against the super lookup tables articles .
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:39 AM
Points: 166,
Visits: 150
|
|
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
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, February 18, 2013 3:06 PM
Points: 8,
Visits: 31
|
|
|
|
|