Viewing 15 posts - 36,421 through 36,435 (of 39,771 total)
Standards are important, mainly to make things easy to find. We've got 60+ SQL Servers, 30 of which I manage. We have a standard hardware setup, 3 physical arrays min...
April 9, 2003 at 11:06 am
only 2 references in BOL. One for the number created per sec, the other seems to link to the Index TUning Wizard. perhaps the server creates files when testing new...
April 9, 2003 at 10:54 am
What do you mean by secure? Security involves the web site setup (need an admin book), SQL setup, good books and advice on the site, and good development practices.
A few...
April 8, 2003 at 1:04 pm
Does dbo exist in all of your database user collections?
Steve Jones
April 8, 2003 at 12:56 pm
Also log in as the SQL Server account, start Outlook (or your mail client) and send mail. Do any dialogs pop up? Or is there some other "funny" thing about...
April 8, 2003 at 12:55 pm
Wow, that's quite a setup. Not sure you'll get an answer here, but good luck. We're primarily for databases, though there are a few good network people here.
Steve Jones
April 7, 2003 at 3:08 pm
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
Viewing 15 posts - 36,421 through 36,435 (of 39,771 total)