Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.
2011-05-02 (first published: 2009-02-21)
13,968 reads
Returns Top 25 fragmented indexes complete with full object name and index name.
2011-04-29 (first published: 2009-05-29)
9,045 reads
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
2,725 reads
Function to get number of days in month
2011-04-27 (first published: 2011-04-21)
2,732 reads
This script kill the user session for particular user database.
2011-04-26 (first published: 2011-04-20)
2,613 reads
Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.
2011-04-21 (first published: 2009-09-03)
5,529 reads
Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it
2011-04-19 (first published: 2009-05-28)
6,035 reads
This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
2011-04-18 (first published: 2008-10-01)
4,634 reads
Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.
2011-04-14 (first published: 2011-03-29)
1,060 reads
Retrieve the charindex of matching string for the desired occurrence
2011-04-13 (first published: 2011-04-06)
1,478 reads