>
Repository

Script 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: rss
601 SQL Server results [Clear]
Denzil Ribeiro
  SQL Server 2012 provides a host of diagnostics  in the form of the System Health extended events session which includes sp_server_Diagnostics collection Here  are a set of Sample reports provide a ‘dashboard’ over the events collected in this session. Key data points covered in
(10)
Updated 4/29/2013
Released 4/29/2013
2,053 Downloads
SQL
Satheesh Variath
This SQL script will compare table columns, Index and foreign keys in two databases. This will show a result with missing objects and the objects with definition mismatch
(5)
Updated 9/30/2013
Released 6/14/2012
2,730 Downloads
SQL
Sorna Kumar Muthuraj
 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
(9)
Updated 12/24/2012
Released 3/16/2012
1,929 Downloads
SQL
RSingh()
Below example demonstrate how we can access file properties using TSQL. The stored procedure retrives all the files properties (i.e file name, size in KB and last modified date) within a specific folder.This can be achieved using T-SQL & OLE automation object i.e Shell Applicatio
(0)
Updated 4/4/2014
Released 8/7/2013
683 Downloads
SQL
Olaf Helper
Using cursor to process data is not best practice and can cause a poor performance.But several developer prefers them, because it's their way of "interative thinking". With the following script you can list all currently open cursor on server level incl the SQL statement.
(1)
Updated 8/28/2013
Released 8/28/2013
614 Downloads
SQL
Aasim Abdullah
Unfortunatly, using a single management view or system you can not find a complete list of database indexes with complete information of  involved columns names. Script will help you to get a list of all indexes of database with its involved column
(0)
Updated 8/16/2013
Released 8/16/2013
282 Downloads
SQL
Chetan_DBA
THis Script provide snapshot of CPU Usage Database wise
& information of Logical CPU, hyperthread_ratio, Physical CPU, RAM
(0)
Updated 7/10/2014
Released 7/10/2014
248 Downloads
SQL
Mohammad Abdul Majeed
We had requirement to capture all the details from SQL server, I am attaching the script which will give you almost all the information from the SQL server. This script will give you the below information from SQL server and databases. 1. Windows Server version and Service
(6)
Updated 10/10/2013
Released 10/8/2013
1,233 Downloads
SQL
Sorna Kumar Muthuraj
This function formats the date and time into mostly all the standard formats and any custom formats also.
(2)
Updated 5/13/2011
Released 5/13/2011
1,515 Downloads
SQL
Olaf Helper
Transact-SQL script to analyse the database size growth using backup history.
(5)
Updated 8/18/2011
Released 8/3/2011
2,302 Downloads
SQL
Manjunath C Bhat
Couple of day back i was working on something very important which will run

some stored procedures to accomplish the task. Now there can be many

transactions or different piece of codes in a Stored Procedure. Now just think

that you come across a weird situation where yo
(1)
Updated 6/27/2013
Released 6/27/2013
672 Downloads
SQL
Olaf Helper
Transact-SQL to list all Objects and Indexes per Filegroup / Partition and Allocation Type including the allocated data size.
(7)
Updated 8/13/2011
Released 7/20/2011
1,892 Downloads
SQL
Mayur-DEW
Compare the objects from a database which is present on both servers & will produce comparison result in excel sheet.
(0)
Updated 9/7/2012
Released 9/7/2012
865 Downloads
SQL
Olaf Helper
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
(8)
Updated 8/26/2011
Released 8/26/2011
2,316 Downloads
SQL
ganeshkuppuswamy
Whenever I need to get the IP address of SQL server then I need to execute some script of XP_cmdshell but in some environment I don't have this feature enabled or I need to execute the IPconfig of machine name in commend prompt to find the IP address .Use the attached script to g
(3)
Updated 11/28/2012
Released 11/23/2012
1,125 Downloads
SQL

Couldn't find the script you were looking for?

16 - 30 of 601 Items