The line:

INSERT INTO @InputBuffer(EventType,Parameters,EventInfo) EXEC (@SQL)

gave me an error:

Server: Msg 197, Level 15, State 1, Line 65

EXECUTE cannot be used as a source when inserting into a table variable.

What...

Hi,

I was scared too about applying on DBA job even I am software developer and worked several years with C++. I was prepared for this kind of interviews by learning...

I knew there are dirty reads and assumed the responsability. But from my ERP system point of view, there is no constraint to view dirty data.

Hi,

Using the LOCK hint to SELECT query it is a very good issue. I have tested it in my production environment and it is very useful. Before that it was...

I couldn't delete the records due to constraints. And there is a lot of constraints (about 80 FKs). Anyway, I followed the solution with uncheck constraints - done operations of...

Yes, I am using also Idera's Diagnostic Manager since a couple of months and I could say that it is fantastic! I solved a lot of problems like blockings, deadlocks,...

yeah, you right. I have a query in my scripts which make the same thing of what you want. I've copied it partially.

Where clause was wrong (id of row is...

UPDATE customers

SET passnumber = passnumber + 12000

WHERE passnumber is null

Hi,

After I have replaced all SELECTs with adding "WITH (NOLOCK)" into the most used stored procedures, the ERP system is working much better. Now, I noticed that people who has...

This audit has not information about date/time of operation and who operated. It has only the activity - type of operation. It is not a real audit.

Maybe I have nothing to optimize by means of SQL. Maybe only hardware.

What is means Bookmark Lookups (see attach) ? I have some big values for its.

I tested the execution of stored proc which contains this query on my workstation (1GB RAM) and time is about 5 minutes and returns about 180 rows.

Also, rowcounts for tables...

I put only few columns, you right, I have many columns to return, but here I show you only involving columns in this bad issue.

Also, the count of values for...

Yes, i already update statistics for stocuri table and have indexes on pairs of indexes like nrintdoc and tipdoc and nothing changes.