|
|
-
|
|
The script below helps to identify the top 10 queries that use the most I/O as ordered by Total IO, taking more time to execute (means most expensive) across all databases on the server....
|
|
-
|
|
This script may help to list all windows services installed on machine....
|
|
-
9
Liked
|
1
Production
|
2
Comments
|
|
We all know the way to create foreign key on column, and we are using UI to create it mostly instead of script. Did you used script to add foreign key?
...
|
|
-
7
Liked
|
0
Production
|
2
Comments
|
|
Script to take database backup, compress it and upload to SFTP...
|
|
-
|
|
This script connects to a SQL Server instance and enumerates all the databases available in it....
|
|
-
|
|
If we are redirecting from one page to another page, using Response.Redirect will send "302" status code, this results in SEO issues. To improve SEO performance, sending "301" status code will be helpful. In .NET 4.0 framework Response.RedirectPermanent method is provided. However, if we are using the framework before 4.0, we can use below script....
|
|
-
|
|
Regular expression for check all uppercase string...
|
|
-
|
|
This quick XQuery script was created to answer a question asked on my blog recently. The following code uses the XQuery functions "position()" and "last()" to determine the last element....
|
|
-
|
|
Read xml data from xml using c#.Net...
|
|
-
|
|
Script to find open active transactions and sessions at database level...
|
|