I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.
2017-10-30
3,911 reads
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,713 reads
Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.
2009-10-12
11,090 reads
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
2009-04-02
2,311 reads
The search results are presented in a grid. User can click on 'select all' or 'select none'. I am not sure there is another way of designing the UI. It is a search page and if the user does not enter any search criteria or enters something that eliminates only few users, I have to […]
2005-02-24
Hi!Made a view, that takes data from tables table1 & table2 from databases db1 & db2. The view itself is in db1. User Smith has "select" right on the view. For "select" statement he gets: Server: Msg 229, Level 14, State 5, Line 1 SELECT permission denied on object 'table2', database 'db2', owner 'dbo'. Both the view and 'table2' have the same owner, […]
2004-01-29
1 reads
I found the answer myself: http://support.microsoft.com/default.aspx?scid=kb;en-us;247527.
2003-06-24
Hi Csaba, sorry, from now on I can only guess. quote: This is the content of the latest Agent log (from ...\MSSQL\Log dir): 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID […]
2003-06-20
Thanks for your info. By the way, to fix the public execute permission, I copied an existing script in this site, and modified it: declare @procname varchar(100), @command varchar(100) declare Crs insensitive cursor for select name as ProcName from sysobjects where type = 'P' order by name for read only open Crs fetch next from […]
2003-06-19
Andy, System has been rebooted many many times. I am unsure as how to disable ODBC Trace or how to check if it is running..? Thanks for the suggestions
2003-06-13
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers