Descargue la versión de Windows 2012Galería TechNet - Recursos para profesionales de TI
Descargue los recursos y aplicaciones para Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, y otros productos. Encuentre los recursos escritos en VB Script, PowerShell, SQL, JavaScript, u otros lenguajes de script. Los nuevos recursos se agregan frecuentemente. Revise a menudo y consulte las novedades.
Cada contribución es autorizada bajo un Contrato de Licencia por su propietario y no por Microsoft. Microsoft no garantiza la contribución ni implica otorgar derechos sobre la misma.
Ordenar por:
|
This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.
|
(14)
Actualizado 29/07/2013
Lanzamiento 16/04/2013
5.607
Descargas
|
|
|
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)
Actualizado 29/10/2013
Lanzamiento 28/04/2011
8.439
Descargas
|
|
|
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)
Actualizado 29/07/2013
Lanzamiento 26/04/2013
2.051
Descargas
|
|
|
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)
Actualizado 14/01/2013
Lanzamiento 29/08/2012
2.139
Descargas
|
|
|
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)
Actualizado 08/01/2013
Lanzamiento 08/01/2013
1.475
Descargas
|
|
|
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)
Actualizado 03/08/2013
Lanzamiento 03/08/2013
300
Descargas
|
|
|
If you already have data in excel sheet, the data is structured in tabular format in the excel, and you want to upload all this data in SQL Server, the attached guide shows the steps to upload the entire data from the excel to SQL Server table using C#.Net
|
(1)
Actualizado 13/02/2013
Lanzamiento 13/02/2013
1.563
Descargas
|
|
|
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)
Actualizado 29/07/2013
Lanzamiento 14/11/2012
960
Descargas
|
|
|
This deck provides a high-level description of SQL Server Master Data Services, which is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transaction
|
(5)
Actualizado 11/04/2012
Lanzamiento 11/04/2012
4.874
Descargas
|
|
|
This is a utility procedure which gives the details like parameters , Datasources , Datasets etc of the given report by querying ReportServer database tables.
|
(18)
Actualizado 31/05/2011
Lanzamiento 30/05/2011
2.396
Descargas
|
|
|
This is a frequent troubleshooting requirement for individual sp_configure values during most SQL performance troubleshooting
|
(8)
Actualizado 29/07/2013
Lanzamiento 14/11/2012
565
Descargas
|
|
|
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)
Actualizado 24/12/2012
Lanzamiento 16/03/2012
973
Descargas
|
|
|
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)
Actualizado 29/07/2013
Lanzamiento 15/10/2012
303
Descargas
|
|
|
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)
Actualizado 29/07/2013
Lanzamiento 15/10/2012
271
Descargas
|
|
|
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)
Actualizado 27/07/2013
Lanzamiento 04/05/2013
295
Descargas
|
|