The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
2011-10-05 (first published: 2011-09-09)
4,246 reads
2011-08-05 (first published: 2011-07-23)
2,178 reads
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
4,996 reads
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-12 (first published: 2008-12-31)
2,113 reads
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-26 (first published: 2008-09-18)
5,869 reads
OK, never mind. Found the book online (took a lot of searching, for some reason). It's called "Dangerous Visions" (1967) and I highly recommend it for SF and/or trip (ta) fans.
2003-09-12
2003-08-21
Hi Mark, The temp table should take care of the number of records. The incentives we're report against generally only run for a couple of months and the data is summarised by consultant anyway. I suspect the largest set would be maybe 300-400 rows. In addition, another parameter defines how many rows we return. Once […]
2003-08-14
1 reads
There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH MOVE. -SQLBill
2003-06-30
A real low-tech way would be similar to the method mentioned by stax68. Create a stored procedure to do the work. Set it as a job to run every minute (or whatever frequency seems necessary). The arguments indicating that the process should be run would be entered into a table from your calling program. When […]
2003-06-27
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