Patching a server is always a good idea, but unless you've run into a bug that's causing the high CPU usage and is fixed in that service pack, it's not...

In that case you don't need a function, look up FOR XML PATH and read up on how to use it for string concatenation.

Add one of the things that Lowell mentioned and monitor for a complete business cycle, be sure to include month and and year end in the time that you monitor...

You're using Oracle. Very different. Basically any query I write for you will not run on Oracle.

And of course the instructions telling you how to get the script out of...

Short answer: You don't.

Custom auditing if you want accurate, persisted data. Or, you can look at sys.dm_db_index_usage_stats, however that only retains information until SQL Server or the database is restarted.

No.

If the procedure was dropped some time ago, it's unlikely that the entry is still in the default trace. It...

Sure. Go read up on sp_create_trace and create one that suits your requirement.

The retention of the default trace isn't measured in time. It's in file size. 5 file of 20...

Modified date tracks schema changes. Not data changes.

Right click table -> script as > Create

Basically, we need you to post setup code so that I can just copy it, paste into Management Studio, hit run and have...

The default trace is 5 files of 20MB each, that's the same on every SQL server.

How far back that goes depends on how active the server is and how...

Also, we need more than one row of sample data please. Enough to test any query written.

Filters on a select to limit down rows until you have the smallest subset that does throw the error. Then look at the computed column definition and see what it...

Even in full recovery, you wouldn't have been able to use that to find something that happened 'some time ago'. The log contains records back to the last log backup/checkpoint.

You...

Unless you have some auditing already set up, you probably can't.

This may indeed be a good time to revisit the security setup on that DB.

Firstly, go buy yourself a copy of T-SQL Fundamentals and read it. Excellent book for someone starting in databases.

Second, to help you we need some more information:

Table definitions (as a...