下載 Windows Server 2012 版TechNet 組件庫 - IT 專業人員的資源
下載 Windows 7、Windows Server 2008 R2、Windows Server 2008、SharePoint、System Center、Office 及其他產品的資源與應用程式。尋找使用 VB Script、PowerShell、SQL、JavaScript 或其他語言撰寫的資源。定期會添增新資源，因此請經常回顧來查看新內容。
每一篇文章皆由文章擁有人 (而非 Microsoft) 根據授權合約授權給您。Microsoft 不擔保文章內容或文章授權意圖。
|
Using an encryption algorithm powerful 256-bit SQL Server, AES encryption can guarantee the security of your most sensitive data. Once one of the data is encrypted, you do not have to worry about a person who reads your confidential information. See more...
|
(2)
已更新 2013/10/16
已發行 2013/10/16
383
下載專區
|
|
|
CHANGE SQL SERVER INSTANCE NAME AND MAKE SURE YOU HAVE MANAGEMENT OF ALL THE DATABASE IN THE PRODUCTION SERVER INSTANCE NAME CORRECT.
FIRST COLLECT THE OUTPUT OF THE CURRENT SQL SERVER INSTANCE CONFIGURATION WITH @@SERVERNAME VARIABLE |
(2)
已更新 2013/10/15
已發行 2013/6/4
259
下載專區
|
|
|
Create a Plan Guide in SQL Server that corresponds to a large query of an application, executed in a repetitive manner (alternating only the values sent to predicates) can be time consuming. Make your queries Foster in SQL Server.
|
(2)
已更新 2013/10/12
已發行 2013/10/12
175
下載專區
|
|
|
This Transact-SQL script returns the values from DMV sys.dm_exec_que
These "costs" can be "Average CPU execution time "Average logical operations" or the total values of these measures. |
(11)
已更新 2012/7/15
已發行 2011/9/1
2,052
下載專區
|
|
|
Article contains the information about an issue that leads to corruption in MS SQL Server backup file, possible ways to prevent data loss at times of corruption in SQL backup file and SQL Backup Recovery that is an affordable solution to repair corrupt SQL backup file.
|
(0)
已更新 2013/4/26
已發行 2013/4/26
242
下載專區
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(4)
已更新 2011/8/18
已發行 2011/8/3
1,522
下載專區
|
|
|
Transact-SQL script to analyse the database size growth using backup history.
|
(16)
已更新 2011/8/13
已發行 2011/8/3
2,459
下載專區
|
|
|
This T-SQL script will refresh all views in a database (regardless of their schema) by calling sp_refreshview.
|
(2)
已更新 2012/9/10
已發行 2012/8/7
321
下載專區
|
|
|
This Transact-SQL statements lists all SSIS packages stored in the msdb system database with detailed information.It gives a brief overview which packages exists, who created them and which is the actual version of it.Works with SQL Server 2005 and higher versions in all editions
|
(7)
已更新 2011/8/26
已發行 2011/8/26
1,707
下載專區
|
|
|
Modeled after SQL Server 2008 Invoke-Sqlcmd, but fixes bug in QueryTimeout.
|
(10)
已更新 2010/10/5
已發行 2010/10/5
|
|
|
List all database tables and there indexes with detailed information about row count and used + reserved data space.
|
(7)
已更新 2011/8/13
已發行 2011/7/24
1,628
下載專區
|
|
|
The Transactional Replication Latency Monitoring Tool provides alerts when transactional subscribers fall behind the publishers, by more than the configured latency threshold. This tool helps reduce downtime and allows app owners to better manage their SLAs with customers.
|
(10)
已更新 2012/11/27
已發行 2012/5/18
741
下載專區
|
|
|
With this simple Transact-SQL statement you can query all heap tables.
|
(2)
已更新 2011/8/25
已發行 2011/8/25
1,324
下載專區
|
|
|
With this Transact-SQL script you can analyse the IO statistics, from total overview down to file level.
Because of the use of CTE (common table expressions) you can easily modify the existing query or create your own statistic. |
(8)
已更新 2011/8/27
已發行 2011/8/27
1,914
下載專區
|
|
|
With this Transact-SQL script you can list all processes with their SQL statements.
Additional you get the cummulative values of IO / CPU usage and the row count of the last statement execution. |
(4)
已更新 2011/8/30
已發行 2011/8/30
1,469
下載專區
|
|