Download Windows Server 2012Script resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by:
|
This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.
|
(14)
Updated 7/29/2013
Released 4/16/2013
5,615
Downloads
|
|
|
To search the whole database for a string in the tables. This stored procedure will return the tables and result set with the matching search string.
|
(33)
Updated 10/29/2013
Released 4/28/2011
8,442
Downloads
|
|
|
This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.
|
(2)
Updated 7/29/2013
Released 4/26/2013
2,051
Downloads
|
|
|
This SQL script will helpful for daily checklist, incase of no any third party tool is available for database monitoring. script will produce the all database size, status, recovery model, data & log file size, spaceused & free space details.
|
(12)
Updated 1/14/2013
Released 8/29/2012
2,140
Downloads
|
|
|
For DBAs to maintain multiple database and monitoring the disk fragmentation and rebuilding the indexes for individual database is quite time consuming task. Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk
space by compacting the pa |
(4)
Updated 1/8/2013
Released 1/8/2013
1,476
Downloads
|
|
|
This article is about multiple ways of splitting a column with delimited string into multiple columns .If the number of delimiters are 3 or less than that then PARSENAME function can be used to Split a column with delimited string into multiple columns like shown below : To make
|
(4)
Updated 8/3/2013
Released 8/3/2013
300
Downloads
|
|
|
This T-SQL sample script illustrates how to check tempdb configuration per best practices. Tempdb is a system database is highly used by Sql Server and an optimal tempdb configuration is generally important for smooth running of the Sql instance.
|
(4)
Updated 7/29/2013
Released 11/14/2012
961
Downloads
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(18)
Updated 5/31/2011
Released 5/30/2011
2,396
Downloads
|
|
|
This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting
|
(8)
Updated 7/29/2013
Released 11/14/2012
565
Downloads
|
|
|
Audit is always a kind of standard requirement in all the trasactional system. For auditing a particular table ,we need to create a similar structure audit table and create Insert , Update and Delete triggers to keep track of the changes in the table. This
is utility procedure |
(5)
Updated 12/24/2012
Released 3/16/2012
973
Downloads
|
|
|
This Windows PowerShell sample script helps you to get the properties of the objects in multiple SQL Server instances or SQL Server groups. It applies to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.
|
(3)
Updated 7/29/2013
Released 10/15/2012
303
Downloads
|
|
|
This script illustrates how to retrieve the top N rows for each group. The first solution can be used with SQL Server 2000 and upward versions, the second solution applies to SQL Server 2005 and upward versions with common table expression feature and Row_Number() function.
|
(4)
Updated 7/29/2013
Released 10/15/2012
271
Downloads
|
|
|
This code will work from SQL Server 2005 and above version . PARSENAME function is the key behind this code.I have developed this code to answer the MSDN forumn thread - http://social.m
|
(2)
Updated 7/27/2013
Released 5/4/2013
295
Downloads
|
|
|
This SQL script is used for maintenance task of reorganizing & rebuilding of indexes task. I have inclued the fragmentation level of indexes is >5 & <30 for reorganizng & above 30 is for rebuild. Result will display as on which indexes task is executed.
|
(6)
Updated 9/7/2012
Released 9/7/2012
731
Downloads
|
|
|
SQL Server 2012 provides a host of diagnostics in the form of the System Health extended events session which includes sp_server_Diagn
|
(3)
Updated 4/29/2013
Released 4/29/2013
838
Downloads
|
|