Laden Sie Windows Server 2012 herunterTechNet Gallery – Ressourcen für IT-Experten
Laden Sie Ressourcen und Anwendungen für Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office und andere Produkte herunter. Es stehen Ressourcen in VB Script, PowerShell, SQL, JavaScript oder anderen Skriptsprachen zur Verfügung. Neue Ressourcen werden regelmäßig hinzugefügt. Besuchen Sie uns daher oft, und erfahren Sie, was es Neues gibt.
Jeder Beitrag wird für Sie von dessen Besitzer, nicht von Microsoft, unter einem Lizenzvertrag lizenziert. Microsoft übernimmt keine Garantie für den Beitrag und erhebt auch keinen Anspruch auf die Erteilung von Rechten darauf.
Sortieren nach:
|
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)
Aktualisiert 03.08.2013
Veröffentlicht 03.08.2013
307
Downloads
|
|
|
Using an encryption algorithm powerful 256-bit SQL Server, AES encryption can guarantee the security of your most sensitive data. Once one of the data is encrypted, you do not have to worry about a person who reads your confidential information. See more...
|
(2)
Aktualisiert 16.10.2013
Veröffentlicht 16.10.2013
383
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)
Aktualisiert 29.04.2013
Veröffentlicht 29.04.2013
850
Downloads
|
|
|
Create a Plan Guide in SQL Server that corresponds to a large query of an application, executed in a repetitive manner (alternating only the values sent to predicates) can be time consuming. Make your queries Foster in SQL Server.
|
(2)
Aktualisiert 12.10.2013
Veröffentlicht 12.10.2013
175
Downloads
|
|
|
This function looks up SQL Instance information via the registry on local and remote systems. Information looked up is Version, Edition type, whether the SQL Instance is part of a cluster and the other nodes in the cluster and
the full name that can be used in another script to |
(2)
Aktualisiert 16.09.2013
Veröffentlicht 16.09.2013
177
Downloads
|
|
|
Running time consuming stored procedures requires sometimes asynchronous processing. We can either implement it within the application by starting new thread and execute stored procedure in that process or we can use MSSQL Service Broker to do it within the database.
|
(0)
Aktualisiert 20.06.2013
Veröffentlicht 19.06.2013
245
Downloads
|
|
|
This T-SQL script will refresh all views in a database (regardless of their schema) by calling sp_refreshview.
|
(2)
Aktualisiert 10.09.2012
Veröffentlicht 07.08.2012
321
Downloads
|
|
|
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 |
(0)
Aktualisiert 27.06.2013
Veröffentlicht 27.06.2013
125
Downloads
|
|
|
The Transactional Replication Latency Monitoring Tool provides alerts when transactional subscribers fall behind the publishers, by more than the configured latency threshold. This tool helps reduce downtime and allows app owners to better manage their SLAs with customers.
|
(10)
Aktualisiert 27.11.2012
Veröffentlicht 18.05.2012
741
Downloads
|
|
|
The script allow you to get list of ODBC connectors from specific machine. It need access via remote registry to source machine.
|
(3)
Aktualisiert 31.05.2013
Veröffentlicht 05.01.2012
828
Downloads
|
|
|
This Article is a combination of expierence , learnings and help of other articles written by many Senior DBA's. The main idea behind is how to use server side trace and complete the activity successfully. here we coverWhen , where and How we should use server side trace. How to
|
(4)
Aktualisiert 07.04.2013
Veröffentlicht 07.04.2013
263
Downloads
|
|
|
The attached script helps to calculate the max server memory for SQL Server. It works with SQL Server 2008 or later. It is a part of my health check scripts.You need to provide the following parameters:
@MemToApps: Mem |
(2)
Aktualisiert 27.08.2012
Veröffentlicht 06.08.2012
424
Downloads
|
|
|
The SQL Server Language Translator is written in C# using the public Bing Translator APIs and extended within SQL Server using a CLR stored procedure & CLR user-defined function. VS 2010 solution, VS 2012 solution, & all SQL Server scripts are included in attached .zip file.
|
(4)
Aktualisiert 12.05.2013
Veröffentlicht 04.05.2013
224
Downloads
|
|
|
Download the given setup to resolve different corruption errors in SQL Server Database. This is the simple way to repair corrupt MDF & NDF File.
|
(3)
Aktualisiert 20.02.2013
Veröffentlicht 20.02.2013
73
Downloads
|
|
|
This script example will connect to a SQL server database (in this example MSDB), query a table (in this example, sys.dm_os_threa Requires powershell v2 or greater. SQL 2012 may have issues because it switched to 'Import-Module' |
(1)
Aktualisiert 07.03.2013
Veröffentlicht 07.03.2013
166
Downloads
|
|