Browse by Tags

• databases
• included
• indexes
• kalen delaney
• performance
• script
• sp_help
• sp_helpindex
• sql queen
• sql server
• statistics
• table
• tsql

SQL Server SP_HELPINDEX - updated version that includes column names
03 January 08 12:46 PM | SQL Master | 2 Comments   

Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA Read More...

Filed under: sql server, indexes, databases, script, columns, sql queen, sp_helpindex, kalen delaney, included, sp_help

How do I find all the statistics and statistics columns on a specified object?
16 July 07 05:46 AM | SQL Master | 1 Comments   

USE <database_name>; GO SELECT s.name AS statistics_name ,c.name AS column_name ,sc.stats_column_id FROM sys.stats AS s INNER JOIN sys.stats_columns AS sc ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id INNER JOIN sys.columns AS c ON Read More...

Filed under: performance, sql server, indexes, table, tsql, statistics, columns