Viewing 15 posts - 36,376 through 36,390 (of 39,720 total)
I think they would still be .sql files, but saved as such and stored somewhere. You could chain them in one .sql with GOs to separate the batches or even...
April 7, 2003 at 12:00 pm
Pls post more information on the job. As well as noting if anything on the server as changed. Even if you don't think it matters, it might.
Steve Jones
April 7, 2003 at 8:43 am
Are you saying that you don't want to return rows if there are NULLs or column values?
You can use ISNULL.
Steve Jones
April 7, 2003 at 8:31 am
Shouldn't matter. This is one of the HUGE things we have over Oracle. Less DBA time spent monkeying with orders of stuff.
Or less developers writing code we have to rewrite...
April 4, 2003 at 2:36 pm
I've not seen this. Is there an affinity set? Check sp_configure for an affinity mask. In general, I've seen both CPUs run at similar levels, though I guess if one...
April 4, 2003 at 2:03 pm
Similar approach to hwat I've done in Part 1 and II. Thanks for sharing
Steve Jones
April 4, 2003 at 1:50 pm
I did find a couple things out. SP_SERVER_INFO reads from a sytem table. @@version reads from the file version of sqlsrv.exe. So I suspect somehow the table didn't get updated...
April 2, 2003 at 12:11 pm
Not sure what you mean? I'm using inserted and deleted tables.
Steve Jones
April 2, 2003 at 11:52 am
considered, but backed up with reviews. I hope to tackle it at some point.
Steve Jones
April 2, 2003 at 11:47 am
Not that I know of. How many machines?
We use SMS, works pretty good.
Steve Jones
April 1, 2003 at 11:28 am
pathing somewhere. Has to do with the different instance numbers.
Steve Jones
April 1, 2003 at 11:26 am
April 1, 2003 at 11:25 am
April 1, 2003 at 11:24 am
Create a new role that deny's access to all tables.
Add the user role to this role at night
run load
remove user role from this role
Steve Jones
April 1, 2003 at 11:19 am
Viewing 15 posts - 36,376 through 36,390 (of 39,720 total)