>
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
594 SQL Server results [Clear]
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
(7)
Updated 12/24/2012
Released 3/16/2012
1,776 Downloads
SQL
SathyanarrayananS
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.msdn.microsoft.com/Forums/en-US/transactsql/thread/b2e55e50-6b20-4ba6-ad76-91da15067a46
(3)
Updated 7/27/2013
Released 5/4/2013
734 Downloads
SQL
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
(9)
Updated 4/29/2013
Released 4/29/2013
1,896 Downloads
SQL
Cephas Lin - Microsoft
(Updated on 9/13/2013)This script is used to aid the configuration of SQL Server 2012 AlwaysOn Availability Groups in
Windows Azure VMs. It creates a functioning WSFC cluster on which you can configure one or more availability groups. It is
not needed for on-premise SQL Server
(3)
Updated 8/29/2013
Released 12/3/2012
1,306 Downloads
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,024 Downloads
SQL
Olaf Helper
SSAS can log query execution information to a relational database.This Transact-SQL script provides a basic query which split the object path data to server name,database ID,cube ID,measure group ID (!always the ID, not the friendly name!)Further it calculates the granularity.
(4)
Updated 9/21/2011
Released 9/21/2011
1,814 Downloads
SQL
Aalamjeet Rangi
This script creates a report about TSQL code to show 1)number of lines of code 2)number of referenced objects 3)number of parameters 4)complexity

More info - http://aalamrangi.wordpress.com/tag/complexity/
(1)
Updated 4/29/2014
Released 12/23/2012
830 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
120 Downloads
SQL
Mayur-DEW
From long time I want to create a one query which will give me a required output of sql server logins, inshort sql server security audit report.Finally I have developed one query which will generate a report in one table having separate details for each task.
(4)
Updated 10/25/2012
Released 10/25/2012
2,039 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,363 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,122 Downloads
SQL
Will Snavely
This script demonstrates how to evaluate the health of an AlwaysOn Availability Group hosted on a SQL Server 2012 instance.
(1)
Updated 2/14/2012
Released 2/15/2012
1,348 Downloads
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
486 Downloads
SQL
Sorna Kumar Muthuraj
The stored procedure will generate the insert scripts for the data present in the given table. Also it supports passing a filter clause to create insert scripts for a subset of data.
(1)
Updated 7/31/2011
Released 7/31/2011
1,060 Downloads
SQL
Olaf Helper
For several business application up-to-date exchange rates for several currencies are required.The ECB publish daily the exchange rates for over 33 currencies over internet for free.With this T-SQL script you can import the ECB exchange rate XML file into a predefined table.
(3)
Updated 11/9/2011
Released 11/9/2011
2,439 Downloads
SQL

Couldn't find the script you were looking for?

16 - 30 of 594 Items