This script is use for filter records in dataset using LINQ ...

It finds the Indexes on Database which need to be De-fragmented. You just need to replace 'database_name' with your database name. Include this Stored Procedure in to your Scheduled JOB, schedule it whenever you want. ...

While inserting multiple rows into a database table, smartest approach is to use bulk copy mechanism. .NET framework has SqlBulkCopy class to copy the rows in bulk to a sql server database table. Following script will be useful in the scenario....

using this script we can read XMl using LINQ...

Have you ever wondered when your index was last rebuilt/reorganized? Here are two versions - using the Catalog view sys.indexes that would help you to identify the last date/time when the index statistics were updated, the number & percentage of rows ch...

Have you ever wondered when your index was last rebuilt/reorganized? Here are two versions - using the Catalog view sys.indexes that would help you to identify the last date/time when the index statistics were updated, the number & percentage of rows ch...

using this script we can serialize Deserialize data...

We recently ran into this interesting problem, to verify whether the IP Address of the user is between the range of IP Addresses or not. Below script will return 1, If IP Address is between the range, otherwise it return 0;...

Often in reporting applications, its required to write data to excel files. By using Excel interops, we can create excel files with various charts,pivot tables etc. Below script can be used to write a dataset to excel file from specific location. ...

Many IT departments use pre-created ghost images to quickly setup development and quality assurance environments. When they change the name of the server after restoring the image, the SQL Server instance name remains unchanged. Here's a script to chang...