I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...
2011-01-13 (first published: 2010-12-29)
1,250 reads
Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table
2011-01-11 (first published: 2010-12-22)
2,455 reads
It will display the multiple
rows values in one row value.Like if there are 5 rows with values then that will be displayed in single row with specified separator.
2011-01-10 (first published: 2010-12-23)
3,619 reads
This procedure creates insert statements for the given table and given range of values of primary key column.
2011-01-07 (first published: 2010-12-23)
2,979 reads
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
2011-01-06 (first published: 2010-12-23)
2,067 reads
2010-12-30 (first published: 2010-03-18)
2,456 reads
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,433 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,673 reads
2010-12-27 (first published: 2010-12-10)
1,156 reads
2010-12-23
3,294 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
I am using the following script to import data from a json file. This...
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Which of these inputs is the smaller input to a hash join?
See possible answers