只要下載之後做以下步驟
1.引用Js
<script src='http://XXX.XXX.XXX/js/prettify.js' type='text/javascript'></script>
2.引用css
<link href='http://XXX.XXX.XXX/css/prettify.css' rel='stylesheet' type='text/css'/>
3.設定css，在style下設定
CODE,.code {display: block; /* fixes a strange ie margin bug */font-family: Courier New;font-size: 8pt;overflow:auto;background: #f0f0f0 url(http://XXX.XXX.XXX/image/BG_CODE.gif) left top repeat-y;border: 1px solid #ccc;padding: 10px 10px 10px 21px;max-height:200px;line-height: 1em;}
4.Body onload執行prettyPrint()
<body onload='prettyPrint()'>
5.在你須需要呈現程式碼前後使用以下TAG包起來就可以
<code class="prettyprint">
程式碼
</code>
搜尋
Blog或網頁上顯示程式語法Code
標籤： Css , Javascript , Web
重建INDEX
根據Defragment程度重建
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
參考SQL2000 Help修改的
SET NOCOUNT ON
DECLARE @tablename VARCHAR (128)
DECLARE @execstr VARCHAR (255)
DECLARE @objectid INT
DECLARE @indexid INT
DECLARE @frag DECIMAL
DECLARE @maxfrag DECIMAL
Declare @IndexName varchar(255)
-- Decide on the maximum fragmentation to allow
SELECT @maxfrag = 30.0
-- Declare cursor
DECLARE tables CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
-- Create the table
CREATE TABLE #fraglist (
ObjectName CHAR (255),
ObjectId INT,
IndexName CHAR (255),
IndexId INT,
Lvl INT,
CountPages INT,
CountRows INT,
MinRecSize INT,
MaxRecSize INT,
AvgRecSize INT,
ForRecCount INT,
Extents INT,
ExtentSwitches INT,
AvgFreeBytes INT,
AvgPageDensity INT,
ScanDensity DECIMAL,
BestCount INT,
ActualCount INT,
LogicalFrag DECIMAL,
ExtentFrag DECIMAL)
-- Open the cursor
OPEN tables
-- Loop through all the tables in the database
FETCH NEXT
FROM tables
INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
-- Do the showcontig of all indexes of the table
INSERT INTO #fraglist
EXEC ('DBCC SHOWCONTIG (''' + @tablename + ''')
WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')
FETCH NEXT
FROM tables
INTO @tablename
END
-- Close and deallocate the cursor
CLOSE tables
DEALLOCATE tables
-- Declare cursor for list of indexes to be defragged
DECLARE indexes CURSOR FOR
SELECT ObjectName, ObjectId, IndexId, LogicalFrag,IndexName
FROM #fraglist
WHERE LogicalFrag >= @maxfrag
AND INDEXPROPERTY (ObjectId, IndexName, 'IndexDepth') > 0
-- Open the cursor
OPEN indexes
-- loop through the indexes
FETCH NEXT
FROM indexes
INTO @tablename, @objectid, @indexid, @frag,@IndexName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing DBCC INDEXDEFRAG (0, ' + RTRIM(@tablename) + ',
' + RTRIM(@indexid) + ') - fragmentation currently '
+ RTRIM(CONVERT(varchar(15),@frag)) + '%'
--SELECT @execstr = 'DBCC INDEXDEFRAG (0, ' + RTRIM(@objectid) + ',
-- ' + RTRIM(@indexid) + ')'
SELECT @execstr = 'DBCC DBREINDEX ('''+ RTRIM(@tablename)+''','''+RTRIM(@IndexName)+''', 70)'
select @execstr
select @tablename, @objectid, @indexid, @frag,@IndexName
FETCH NEXT
FROM indexes
INTO @tablename, @objectid, @indexid, @frag,@IndexName
END
-- Close and deallocate the cursor
CLOSE indexes
DEALLOCATE indexes
-- Delete the temporary table
DROP TABLE #fraglist
GO
標籤： SQL
