/*updating existing values*/

UPDATE MATBIT INNER JOIN [NewPrice List] ON MATBIT.ITEMCODE=[NewPrice List].ITEMCODE SET MATBIT.PRICE = [NewPrice List]!MATBITPRICE, MATBIT.DESC_Col = [NewPrice List]!MATBITDESC_COL;

/*inserting new values*/

INSERT INTO MATBIT

(PRICE,DESC_Col,ITEMCODE )

SELECT NoSpaces.MATBITPRICE,...

FROM [NewPrice List] NoSpaces

WHERE...

finding bottleneck:

Look at the performance counter (cpu, I/O)?

sp_who2 gives some information about connections, if they are blocked and the amount op cpu,io since the connection started

sql profiler can start a...

I havent't used this one, but there is an option-clause for the select statement

USE pubs

SELECT a.au_fname, a.au_lname, SUBSTRING(t.title, 1, 15)

FROM authors a INNER JOIN titleauthor ta

ON...

If you use triggers be sure to add the line

SET NOCOUNT ON after the "AS" to reduce roundtrips.

CREATE TRIGGER LastEditDate ON ManifestHeader FOR INSERT,UPDATE

AS

SET NOCOUNT ON

...

see

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057991,00.html

Depends on how high the fragmentation level is. One advantage of dbcc indexdefrag is that you can continue to work. A disadvantage is that all it operations are logged, resulting...

Hello,

Have a look at:

http://support.microsoft.com/kb/283811

*lost typing

Have a look at

http://www.sql-server-performance.com/sql_server_performance_audit.asp

for some info about performance counters etc.

Resetting the service also clears any outstanding transactions/locks. Try to figure out which queries are taking longer (sql profiler),...

perhaps this

http://support.microsoft.com/kb/175239

Is the server up to date with patches?

The DTC authentication thing is new from windows 2003/XP SP2. So no authentication is required if you have to support windows 2000,NT4...

see http://support.microsoft.com/kb/839279

I can't figure out an easy way. With enterprise library of .NET you can relaunch technical exceptions with user-friendly error messages.

Darn copy paste errors.

Try

Select EmplNO, Max(CTdate) As MaxDate, QuizName

From    tblPreviousWinTrainingLog b  

WHERE (@fromdate is null or CTDate > @fromdate )

AND  ( @todate is null or CTDate <@todate)

AND  (@quiz is null or b.QuizName...

First thing to check if there is anything mentioned in the event-log of windows regarding sql server. This can give a better indication of what the error is (perhaps database ......

Plans are dependant on hardware,software version,statistics,...

Can you isolate the bad performing query (with sql profiler, ... ) and compare the execution plan?

rewrite the first part in . The begin is left out and

fixed the condition @quiz is null in the having clause

Set @quiz = NullIf(@quiz, '')

Set @Unit = NullIf(@Unit, '')

...

Hello,

Can you test if the server is running? (ping...)

What kind of technology you use to connect to sql server (ado,ado.net,oledb,odbc,...) ?