Viewing 15 posts - 301 through 315 (of 359 total)
As a DBA among developers you do a lot of helping, and that's good. That's the sort of position you want. A DBA who is a speed bump in the...
April 25, 2003 at 11:34 am
Laughing.
As a DBA who has been a project manager I would say that yes, far too many projects are built on inadequate databases created by programmers.
But blaming it all on...
April 25, 2003 at 7:03 am
hot -
I just had a discussion about SQL2K's tempdb. We had four DBAs talking about the various ways the system really uses it as opposed to what the manuals say.
And...
April 25, 2003 at 6:53 am
Oh, the TempDB is not recreated in the sense that what was there when you stopped service is restored. I meant that it is created fresh (based on the size...
April 16, 2003 at 7:38 am
Do you have any transactions running? Are you shrinking the transaction log?
Patrick
April 15, 2003 at 2:56 pm
Well, it depends on other variables - the size of the fields, data types, etc, and the type of transactions.
A sequential number should not be the primary key if none,...
April 15, 2003 at 7:57 am
Take the exam first while the information is fresh. I've known a few guys who took the course and scheduled the exam either the evening of the last day or...
April 15, 2003 at 7:33 am
I have the advantage of working on SQL Server while I studied for the tests. I was working with a much more experienced DBA and I would check my reasons...
April 14, 2003 at 11:23 am
That makes sense since the Temporary database is recreated each time the server starts.
The concern with autoshrink is that it may run at high peak times. It should also...
April 14, 2003 at 7:44 am
Access .mdbs can be flaky. They are fine for non-critical uses, and if the users are trained to back up often and there are not a lot of users or...
April 11, 2003 at 11:51 am
Ah, the money. It's when you look for the next job and can point to the experience that you have that will help with the money. The DBA cert will...
April 10, 2003 at 8:04 am
Well, nothing kills a discussion on certifications quicker than saying how wonderful braindumps are.
Patrick
April 9, 2003 at 1:29 pm
You know I didn't think of that. Laughing. Too focused on indexing and joins.
Patrick
April 9, 2003 at 11:40 am
Kevin,
Glad I could help.
Yes, just add a line to the job that dumps the data in to update statistics. And don't rely on auto anything...
Laughing.
Patrick
April 9, 2003 at 11:14 am
It could be a mixture. From this distance it's hard to tell.
A nested loop join joins the tables in a series of nested iterations. In a two-table join every...
April 9, 2003 at 8:37 am
Viewing 15 posts - 301 through 315 (of 359 total)