skip to main
|
skip to sidebar
Moments shared with SQL Server
Wednesday, March 17, 2010
Statistics basic
To list all of the statistics being maintained on a table-
select * from sys.stats where object_id = object_id('brkprd')
To retrieve detailed information about an index or statistic
dbcc show_statistics ('brkprd','IX_Brkprd_AcctIdIsNonZeroBP')
Newer Post
Older Post
Home
Blog Archive
►
2013
(1)
►
January
(1)
►
2011
(4)
►
October
(1)
►
June
(1)
►
May
(1)
►
April
(1)
▼
2010
(23)
►
December
(1)
►
September
(4)
►
August
(1)
►
July
(1)
▼
March
(4)
Notes on Index Rebuild/Reorganize
Statistics basic
More on indexes
Sorting Number Strings
►
January
(12)
►
2009
(1)
►
May
(1)
►
2008
(14)
►
April
(1)
►
March
(2)
►
February
(11)
►
2007
(16)
►
October
(7)
►
September
(4)
►
August
(4)
►
May
(1)