SQL SERVER – Running Multiple Batch Files Together in Parallel

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Sun, 06 Mar 2011 01:30:15 +0000 Indexed on 2011/03/06 8:13 UTC
Read the original article Hit count: 499

Filed under:

Pinal Dave

|

PostADay

|

sql

|

SQL Authority

|

SQL Query

|

SQL Scripts

|

SQL Server

|

SQL Tips and Tricks

|

SQL Utility

|

T SQL

|

Technology

Recently I was preparing a demo for my next technical session, I had to do run a SQL code in parallel. I decided to use Batch File to run the code.

I am not the best guy to with command shell so I did it with following setup.

Code of tsql.sql

SELECT 1 ColumnName

Code of command.bat

sqlcmd -S . -i tsql.sql
timeout 100

Code of AllBatch.bat

start cmd.exe /C “command.bat”
start cmd.exe /C “command.bat”
start cmd.exe /C “command.bat”

Now I ran AllBatch.bat and it run all the three files in parallel and simulated my needed scenario.

I believe there should be simpler way using power-shell. Anybody want to come up with equivalent code which is improvement to this code?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology

© SQL Authority or respective owner

Related posts about Pinal Dave

SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart

as seen on SQL Authority - Search for 'SQL Authority'
Michael J. Swart is a very unique person. I have often exchanged emails with him and also used a couple of his scripts in my presentations (with his permission). Every time I conduct spatial database presentation, I always start with his script where he has drawn the wonderful image of Botticelli’s… >>> More
SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this year Lohith (@kashyapa) from Bangalore took my ‘Uncut and Unedited’ video interview. It was really fun to answer his questions as it was very different from regular interview. He asked few personal details few technical details and made me show few secrets. I think if you… >>> More
There seems to be some 'lingering' SSH connections on my server. How do I fix it?

as seen on Server Fault - Search for 'Server Fault'
[root@server mike]# w 14:43:35 up 83 days, 1:25, 1 user, load average: 0.00, 0.00, 0.00 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT mike pts/1 dsl-IP.w 14:43 0.00s 0.01s 0.03s sshd: mike [priv] [root@server mike]# ps aux | grep ssh root 1350 0.0 0.1… >>> More
SQLAuthority News – DotNET Challenge of Sorting Generic List

as seen on SQL Authority - Search for 'SQL Authority'
This is a quick announcement of .NET challenge posted by Nupur Dave. She has asked very interesting question. If you are interested in learning .NET and winning iPAD by Red-Gate. I strongly suggest that all of you should attempt the quiz. Here is the question: How to insert an item in sorted generic… >>> More
SQLAuthority News – SQL Server Technology Evangelists and Evangelism

as seen on SQL Authority - Search for 'SQL Authority'
This is the exact conversation that I had with three people during the recent SQL Server Public Training. Person 1: “Are you an SQL Server Evangelist?” Pinal : “No, but Vinod Kumar is.” Person 1: “Who are you?” Person 2: “He is Pinal, haha!” Person 1: “I… >>> More

Related posts about PostADay

SQL SERVER – How to See Active SQL Server Connections For Database

as seen on SQL Authority - Search for 'SQL Authority'
Another question received via email - “How do I I know which user is connected to my database with how many connection?” Here is the script which will give us answer to the question. SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP… >>> More
SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28

as seen on SQL Authority - Search for 'SQL Authority'
This blog post will have running account of the all the blog post I will be doing in this month related to SQL Server Wait Types and Wait Queues. SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28 SQL SERVER – Single Wait Time Introduction with Simple Example – Wait Type… >>> More
SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

as seen on SQL Authority - Search for 'SQL Authority'
Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here. Read second part over here: Quick Look at SQL Server… >>> More
SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2

as seen on SQL Authority - Search for 'SQL Authority'
An integral part of any BI system is the data warehouse—a central repository of data that is regularly refreshed from the source systems. The new data is transferred at regular intervals by extract, transform, and load (ETL) processes. This whitepaper talks about what are best practices for Data… >>> More
SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name

as seen on SQL Authority - Search for 'SQL Authority'
Quite often a simple things makes experienced DBA to look for simple thing. Here are few things which I used to get confused couple of years ago. Now I know it well and have no issue but recently I see one of the DBA getting confused when looking at the DBID from one of the DMV and not able to related… >>> More