Viewing 15 posts - 5,701 through 5,715 (of 6,105 total)
I think one of the factors is that there aren't a lot of DBA slots for entry level. I was doing a search for Oracle jobs in the DC...
February 6, 2002 at 8:06 am
Take a look at SQL 2000 Administrator's Companion, or simply the Pocket book from MS Press.
K. Brian Kelley
February 6, 2002 at 8:02 am
When you are talking about data movement, how much data?
K. Brian Kelley
February 6, 2002 at 8:00 am
aribi,
One question i never asked is if you have this operating in multiple environments (say development and production) with the same issue?
K. Brian Kelley
February 6, 2002 at 7:54 am
Please do write that article. I know quite a few of us are interested in your findings.
K. Brian Kelley
February 6, 2002 at 7:41 am
I would agree with James in that you should probably run a profile trace and watch carefully as you get close to the estimated time. However, since there are...
February 6, 2002 at 7:36 am
Off hand I don't see any issues, but I generally try to build the dynamic SQL string outside of the EXEC statement. Try declaring an nvarchar variable like:
DECLARE @sql...
February 6, 2002 at 7:33 am
There are some changes in the .NET Server family that are more than just Windows 2000 with the CLR. They are making some noticeable changes to AD (namely the...
February 5, 2002 at 3:36 pm
quote:
I like it for the most part, but considering the antitrust case I am surprised Microsoft is being given such a pivotal...
February 5, 2002 at 3:13 pm
quote:
The procedure is very very big, over 745 000 lines long and when added to the cache uses up nearly 1 gig...
February 5, 2002 at 2:41 pm
It sounds like something is interrupting the session causing the connection to drop. Your application, thinking there's still a connection, goes to talk, and finds this isn't the case....
February 5, 2002 at 2:34 pm
If the @Pn are user defined values, then there should be preceding events which show these values being set. Are these parameters being passed to a stored procedure or...
February 5, 2002 at 2:15 pm
Bill,
When you say embedded paths, were paths hard-coded into stored procedures and/or DTS ActiveX Task Steps?
K. Brian Kelley
February 5, 2002 at 2:09 pm
Yes, this is the BUILTIN\Administrators group and it maps to the local Administrator group on the server. There are times when it's a good idea to remove this group......
February 5, 2002 at 2:06 pm
ZoneAlarm is looking at port reservations and when SQL Server asks for exclusive use of port 1433 via TCP, it is tagged as a server, which in the client-server nomenclature,...
February 5, 2002 at 1:59 pm
Viewing 15 posts - 5,701 through 5,715 (of 6,105 total)