The special keyword "DEFAULT VALUES" is part of the SQL Standard with usage of:

Insert into dbo.Transactions DEFAULT VALUES

I have set up tracing on about 80 Servers that runs on a 24x7 basis with the trace being stopped and then restarted once a day and have run into...

For inserts, you can use defaults and for updates, see the article "Triggers for Auditing" at

http://www.sqlservercentral.com/columnists/tsilva/triggersforauditing.asp

"It wasn't by the 17 times that Carl claimed (I never do trust CPU times, just elapsed times)"

Actually, the the test results were:

In a two minute duration:

1. Execution counts was...

The isql utility does not support Unicode input files.

Alternative solutions are:

1. When you generated the script, change the output from the default of UniCode to Windows.

2. Run...

Do you have any groups that have been denied access ?

If do the deny overrides the grant and the login will not be able to connect.

You can confirm if the...

Does this message appear in the SQL Server log ?

Database log truncated: Database:

If so, someone is executing a "backup log with truncate_only"

Who has sa or database owner rights ?

Does this message appear in the SQL Server log ?

Database log truncated: Database:

If so, someone is executing a "backup log with truncate_only"

Who has sa or database owner rights ?

Does this message appear in the SQL Server log ?

Database log truncated: Database:

If so, someone is executing a "backup log with truncate_only"

Who has sa or database owner rights ?

Does this message appear in the SQL Server log ?

Database log truncated: Database:

If so, someone is executing a "backup log with truncate_only"

Who has sa or database owner rights ?

You can advise SQL Server that the ConcStatus derived column exists by nesting the select in a from. This is easier to read if you indent the nested select.

select...

You can advise SQL Server that the ConcStatus derived column exists by nesting the select in a from. This is easier to read if you indent the nested select.

select...

I have re-done the same performance comparison but captured resource utilization from the sysprocess table instead of using a trace.

On the average CPU Milliseconds with sysprocess versus trace

For UDFs, ...

I have re-done the same performance comparison but captured resource utilization from the sysprocess table instead of using a trace.

On the average CPU Milliseconds with sysprocess versus trace

For UDFs, ...

I have re-done the same performance comparison but captured resource utilization from the sysprocess table instead of using a trace.

On the average CPU Milliseconds with sysprocess versus trace

For UDFs, ...