Pro/Gar,

You may also want to check http://www.brainbench.com. They have some decent materials but will charge.

I am currently studying as well and am using Microsoft Press books...

I agree with the others. Also, you may want to look at your WHERE clauses to ensure that your are using Indexes.

Run Profiler and see if you have some...

Is the ID field an IDENTITY field?? If it is you can SET IDENTITY_INSERT ON

Then you can insert your identity from table a into table b.

AJ Ahrens

SQL DBA

Revenue Assurance...

If you change what you are doing (in keeping with 540) from a lot of SELECT INTO * and UPDATE * to

DECLARE @PROC_START_ID int

INSERT INTO pricelist_trace (proc_start_time)

VALUES (GetDate())

SELECT...

I run the following on our system when the SHRINKDATABASE doesn't work properly

For this example the Database is named DB and the MDF is named DB_Data.MDF

DBCC SHRINKFILE(DB_Data, [enter size to...

Ali,

Be careful of your insert statements as well. If the order of the columns changes from either your select * or your insert into your code will fail.

If...

One thing you can do is set-up the table(s) so that the SQL login that is used by the web application can only INSERT and not SELECT/UPDATE/DELETE. Also, you...

I would definitely listen to Antares and Prab and set-up Profiler. You may need to do the "tweaks" for the memory but the real problem is the amount of...

You may also want to select PER step to write to a log. This might also give clues to why steps fail as well.

Glad your problem is fixed

AJ Ahrens

SQL...

I have 1 developer that uses this tool. First time I have ever EVEN seen it. Personally I dont like the tool.

We had problems with it after converting...

Quick question.

When you changed to the new area did you change the network segment? I know that network traffic works best "named pipe" over WAN and between physical locations...

I would like to add to what Steve Jones has said about experience and the whole "right" thing.

Even if you think you may have the answer it is better to...

I have been lucky in my training path as well to be mentored by someone who trained themselves into a DBA position.

I worked for several years with him (I cam...

In that case you would have to do multiple different returns (to avoid dups)

In the case of my SQL statement sample could you just add WHERE accidentId = n??

This way...

I would probably create something like the following:

SELECT WitnessFirstName, WitnessSecondName

FROM WitnessTable

ORDER BY WitnessId

This way it returns the data in the proper order for you to populate back into your form.

It...