Tag Info

New answers tagged


:setvar backuppath = "e:\sql\restore\PROD.bak" should be :setvar backuppath "e:\sql\restore\PROD.bak"


The whole point about profiling is to ascertain where your system is spending time. This can often give developers some clues as to how to optimise their queries (by adding indexes for example). The 600 pound gorilla in this area is Oracle's Wait Interface (OWI) which is one of the most sophisticated monitoring and profiling tools available to database ...


If the UPDATE statement is shown in Profiler with no error, then does this mean that it should have updated the database? Yes, but whether the change is visible to other database connections depends on whether the change is committed or not, and on the current transaction isolation level in use by the other connection. To be clear, the ...

Top 50 recent answers are included