Viewing 15 posts - 796 through 810 (of 2,436 total)
Thank You Jeff ... now back to my paper and pencil ...
April 24, 2007 at 8:20 am
ftp sounds great but it is not secure. The user ID and password are sent over the wire in clear text !!! Do a bit more homework and possibly spend...
April 23, 2007 at 5:56 pm
As a cleanup activity you might want to check the default database of the first userid that was executing the JOB. You may have some table cleanup in that database...
April 23, 2007 at 5:39 pm
What about unchecking Auto Updating Statistics for the database in question ...
April 23, 2007 at 5:36 pm
I agree with Jeff and a great many other in the posting. I definitely have seen very 'few' worth their salt. It is not the people, it is the curriculum - more...
April 23, 2007 at 5:24 pm
All of the banter here has shown the multiple methods of solving a SQL problem. I for one have learned no matter what the initial impetus of the post.
April 23, 2007 at 4:17 pm
We are Borg, We have adapted ...
CTRL-A, CTRL-C, CTRL-V are now automatic keystrokes when replying to any post !
April 23, 2007 at 4:02 pm
Are you restricting the 'import' by batchsize ? If not then you should probably look into a 'batchsize' of around 100,000 rows. If you do not do this then the...
April 23, 2007 at 3:29 pm
You should still be careful though ... dropping an index can have rather SEVERE performance impacts if it is one used frequently. Just imagine all of the lookups, index seeks, etc...
April 23, 2007 at 1:29 pm
The process is already syncronous and serial .. step 1 executes and conditionally then step 2 executes.
What is the real issue or problem that you are having ?
(oh, I'd also...
April 23, 2007 at 1:24 pm
Granted this is a late response (I'm about 2 weeks behind in SSC newsletters) ...
My point is that since 1988 every position that I have held I have been subject...
April 23, 2007 at 1:15 pm
I dunno for sure but I believe that you can have a 2005 MSX and a 2000 TSX but not the reverse as you are trying.
April 23, 2007 at 1:04 pm
One step was possibly missing and some refinements:
use master
go
exec sp_addlogin @loginame='THE_LOGINAME', @passwd='A_very_Secure_Password', @defdb='THE_DATABASE_NAME'
exec THE_DATABASE_NAME..sp_adduser @loginame='THE_LOGINAME'
exec THE_DATABASE_NAME..sp_addrolemember @rolename='db_datareader', @membername='THE_LOGINAME'
go
checkpoint
go
April 23, 2007 at 12:58 pm
Talk to the folks at TUSC (http://www.tusc.com) they provide training to Oracle themselves and are partners. I've taken the Admin and Perf Tuning classes. My training was in Chicago,...
April 23, 2007 at 12:39 pm
Good question. But architecturally speaking, a SQL server should always have a minimum of 2 CPUs.
April 2, 2007 at 11:15 am
Viewing 15 posts - 796 through 810 (of 2,436 total)