Viewing 15 posts - 331 through 345 (of 508 total)
Also, what account is sql agent running under? Permissions on that account could keep the job from running. When you run it from EM you are using your login rights...
February 5, 2003 at 4:04 pm
Sounds like you could be running your tempdb out of space and it is having to grow to meet the needs of joining all those rows in tempdb. I would...
January 28, 2003 at 2:33 pm
Personally, I would stick to the load tables as well. Even for small jobs. What I have found is that small jobs end up growing over time and your cursors...
January 28, 2003 at 1:56 pm
Step by Step microsoft SQL Server 2000 Analysis Services is a wonderful book to start with.
Wes
January 28, 2003 at 1:52 pm
Well, I don't think anyone here can provide your job description. Take a look at what you know you are responsible for. Also, look at all the things you do...
January 28, 2003 at 1:49 pm
Sorry, on the DL760 nothing bigger than 900mhz period they are comming out with a new box in march time frame that will use the new P4's I was just...
January 20, 2003 at 12:05 pm
I haven't seen any thing bigger than 1.4 or 1.6 with 2mb cache on them.
January 20, 2003 at 7:49 am
I personally haven't done alot of work with IBM servers. I would recommend calling IBM and getting their recommended setup for a cluster.
January 19, 2003 at 6:44 pm
go with as much cache on the proc as possible data close to the processor is very important. We have several machines with faster procs but the ones with more...
January 16, 2003 at 7:54 pm
Same here, I just usually go back in and fix logins and jobs. It's kind of a pain to restore master. BOL recommends detaching and reattaching databases then recreating logins...
January 8, 2003 at 3:40 pm
If I'm not mistaken you can restore master from a non-clustered to a clustered envionrment. I'll do some checking to make sure. What reason other than logins and the like...
January 8, 2003 at 7:08 am
For availablility clustering is really your only solution unless you app is coded to check multiple servers for the same data. I have always found clustering to be easier to...
January 5, 2003 at 9:50 am
I'm in the same boat as many of you are. I'm use to working with high volume severs with tons of smaller tables and hundreds of concurrent users, now I...
January 3, 2003 at 3:31 pm
I don't think we are on the same page. As far as the OS and SQL are conserned if you have a hyperthreading cpu and hyperthreading is enabled on the...
January 2, 2003 at 2:30 pm
If you configured the OS as single processor then hyper threading doesn't come into play at all the OS and SQL only "sees" one processor. Hyperthreading makes the OS "see"...
January 1, 2003 at 5:00 pm
Viewing 15 posts - 331 through 345 (of 508 total)