Télécharger Windows Server 2012Ressources de script pour les professionnels de l'informatique
Téléchargez des ressources et des applications pour Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office et d'autres produits. Découvrez des ressources écrites en VB Script, PowerShell, SQL, JavaScript ou d'autres langages de script. De nouvelles ressources étant régulièrement ajoutées, revenez souvent consulter cette page pour découvrir les nouveautés.
Chaque contribution vous est concédée sous licence en vertu d’un Contrat de licence par son propriétaire, et non par Microsoft. Microsoft ne garantit pas la contribution et ne prétend pas accorder de droits pour celle-ci.
Trier par:
|
This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.
|
(14)
Mis à jour 29/07/2013
Disponible 16/04/2013
5 614
Téléchargements
|
|
|
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)
Mis à jour 29/10/2013
Disponible 28/04/2011
8 442
Téléchargements
|
|
|
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)
Mis à jour 29/07/2013
Disponible 26/04/2013
2 051
Téléchargements
|
|
|
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)
Mis à jour 14/01/2013
Disponible 29/08/2012
2 140
Téléchargements
|
|
|
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)
Mis à jour 08/01/2013
Disponible 08/01/2013
1 475
Téléchargements
|
|
|
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)
Mis à jour 03/08/2013
Disponible 03/08/2013
300
Téléchargements
|
|
|
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)
Mis à jour 29/07/2013
Disponible 14/11/2012
961
Téléchargements
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(18)
Mis à jour 31/05/2011
Disponible 30/05/2011
2 396
Téléchargements
|
|
|
This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting
|
(8)
Mis à jour 29/07/2013
Disponible 14/11/2012
565
Téléchargements
|
|
|
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)
Mis à jour 24/12/2012
Disponible 16/03/2012
973
Téléchargements
|
|
|
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)
Mis à jour 29/07/2013
Disponible 15/10/2012
303
Téléchargements
|
|
|
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)
Mis à jour 29/07/2013
Disponible 15/10/2012
271
Téléchargements
|
|
|
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)
Mis à jour 27/07/2013
Disponible 04/05/2013
295
Téléchargements
|
|
|
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)
Mis à jour 07/09/2012
Disponible 07/09/2012
731
Téléchargements
|
|
|
SQL Server 2012 provides a host of diagnostics in the form of the System Health extended events session which includes sp_server_Diagn
|
(3)
Mis à jour 29/04/2013
Disponible 29/04/2013
838
Téléchargements
|
|