Viewing 15 posts - 1,591 through 1,605 (of 6,216 total)
How about serializing the jobs? Either combine into one, or have each check to make sure no other is running before proceeding.
Andy
September 15, 2003 at 1:46 pm
Do you have the snapshot configured to drop/create the schema each time?
Andy
September 15, 2003 at 1:45 pm
Thanks Phil, I shoulda remembered that! A nice side affect of that shell is you can shell and continue, or shell and wait. Nice to be able to easily control...
September 15, 2003 at 5:18 am
Deadlocks are tough. Can you post the output of the deadlock from the log? One way to avoid is to see if you can avoid all locks by setting your...
September 15, 2003 at 5:17 am
Not possible. You set something up so that you run it via sql agent maybe as a "proxy", but the job would still need sysadmin rights.
Andy
September 15, 2003 at 5:12 am
Readers, I'll be posting an article that covers these points and more in the next week or so. If you've got comments in the interim, please feel free to post.
Andy
September 15, 2003 at 5:10 am
We may well take you up on that! Bear with me another day or two, we'll see if we can't make some changes that will increase the number of reviews...
September 14, 2003 at 3:31 pm
Hello Alex,
Other than a cursory glance, no, I have not yet tried either of your products. Your tool is still next on my list to be reviewed (from our early...
September 14, 2003 at 6:27 am
Here's a start:
1) Copy the mdf to your data folder.
2) Open Query Analyzer, connect to your server, set the database to master.
3) Type EXEC sp_attach_single_file_db @dbname = 'yourdbname here',
...
September 13, 2003 at 10:33 pm
I'd stick with standard index on the primary key, look at using the clustered index for the date. Probably need to take a look to see what datepart is costing...
September 13, 2003 at 6:39 pm
Exactly. Unfortuneately it forces you into dynamic sql, with the associated perf hit and security consequences. One alternative (which may give you ideas about how to do the same thing...
September 13, 2003 at 2:34 pm
Partitioning to get perf data seems extreme, but I honestly haven't thought it out yet.
Andy
September 12, 2003 at 9:22 pm
Depends on what you want to move. I've got an article up that describes one way to do it, simpler (in some ways) is to do backup/restore, or detach/copy/attach.
Andy
September 12, 2003 at 9:18 pm
For transactional it will not add columns (but you have to have a primary key defined on the table in order to select it). If you want to use queued...
September 12, 2003 at 9:17 pm
Can't remember if you can shell from VBScript. Could always do it via xp_cmdshell - just pass 'copy file1 + file2 file3', I think is the syntax.
Andy
September 12, 2003 at 9:15 pm
Viewing 15 posts - 1,591 through 1,605 (of 6,216 total)