Hi,

Sergiy's solution surely has the potential for updating 1000 rows at a time at unspecified physical locations throughout 'table'. This has the potential to lock disparate areas of the table...

Good common sense Pam! Thanks!

I'd like to add another one please.

Make the code modular (if your system will support it).

Extract frequently used functionality to a separate code module, and call...

Hi,

You could run profiler regularly and capture long-running queries. eg: Event->SQL:Batch Completed, Duration->Greaterthanorequalto 2000.

I just run a little script in QA locally on the server at the end of...

Do you need a cursor ?

Perhaps if we could see a bit more of the box this mystery comes in...?

David

Hi

Could also possibly be out of date cached query plans or compiled procedures. The cache would be wiped when you restored the database.

I use

EXEC sp_msForEachTable 'EXEC sp_recompile ''?'''

and

dbcc freeproccache

once in...

I think the evaluation Enterprise Edition that comes with the SQL Server 2000 System Administration book will install on Windows XP Professional, but it only works for 120 days of...

Hi, my thoughts on the subject, not sure if they will be of any help...

If 'x' is the only login, and current_user returns dbo, then 'x' must be a member of the...

Test test test is right Wayne.

I installed the freely distributed version 1.0 of SQLPrompt on my machine, and it ran away with all the system resources, taking 99% of...

Hi,

I tend to use table valued UDFs for this purpose. You can use these in a JOIN statement as though they were tables. The gotcha, is that unlike inline UDFs...

Hi Gabriel

I'm no expert, but I have had similar problems with differences between queries executed in Query Analyser and in EM, and I eventually resolved them by comparing the connection...

Sometimes you don't have to be too smart to out-think the criminals. I used to work at a University in the North West of England. We had a break-in in...

No...

I have a degree and post grad in Biology. When I joined the computing services department of a university 20 years ago, I told them I had no qualifications in...

Hi,

I manage a Borland delphi application running on SQL Server 2000, using dbexpress to connect the database. We had really bad contention between the reporting and the updating aspects of...

It is interesting that you refer to # as 'sharp' I did a SQL Server Training Camp course recently in the UK, with an instructor called Samir from the US....

I wonder are there any figures available for the take-up of SQL Server 2005 that differentiate new installations and migrations/upgrades?

David