Yes, where it's triggers and stored procedures, it's easy - just look up the definition.  But where it's adhoc, you need to get it from the plan cache.  There are...

I say no, investigate now!  Start by fetching the execution plans (and the full query) for those statements.  You can also get aggregate execution stats such as numbers of reads...

DECLARE @Return int;
EXEC @Return = MyProc;
SELECT @Return; -- or try PRINT or RAISERROR

John

Jon

Use COUNT(*) with a PARTITION BY clause to show the number of rows per NUMBER.  If you want to return only those rows with NUMBER greater than 1,...

Start with sys.master_files.  It should be a simple matter to query that to find out where the log file is the largest file, or whether all the log files add...

Sorry, yes, that's the AuditTable table.  I tried to soften the object names and make them more generic sounding, but clearly I missed one line out!

John

Just set up a job that imports the data from the audit file every 15 minutes or whatever interval is suitable for you.  You can have this for free:

Neil

I've been to Iceland at that time of year, and it can be very cold - especially if she plans to stand outside in the middle of the...

SQL Audit?  You may need Enterprise Edition to do database-level auditing in 2012, though.

John

Yes, or you can use LIKE.  I don't know whether it'll be more or less efficient than CHARINDEX, or exactly the same - you'll need to test.

[code...

Use INSERT...SELECT.  You can do it all in one go, or you can break it into batches if you're worried about blowing your transaction log or locking too many rows...

Almost certainly.  Please post the actual (not estimated) execution plan.  And when posting code, try to look as if you care about it - if you don't then it's likely...

(1) Find a suitable folder on the server to which the SQL Server Agent account has at least read permission
(2) Copy the .dtsx file to that folder
(3) Amend...