I concur with Michael and Sean. Triggers can be useful when properly designed, but are more often misused leading to performance problems, permissions issues, and in one case I recall...

The query optimizer will determine whether or not index is useful when it evaluates potential execution plans. Aside from forcing an index hint in the query (which is almost always...

Automatation and standardization. By running a post deployment script after every SQL Server install, we make sure that all configurations are standardized throughout the Enterprise. No more mail profiles with...

Also, how big is the database? That will impact the amount of time that the system is offline while the restore runs.

I am a huge fan of scripting EVERYTHING that...

Yes, the option is still valid in 2012: http://msdn.microsoft.com/en-us/library/ms186865.aspx. It is equivalient to using both COPY_ONLY and CONTINUE_AFTER_ERROR.

NO_TRUNCATE

Specifies that the log not be truncated and causes the...

Love it, mind if I quote you the next time someone asks me that question?:-D

SQL 2000 is a tougher one. Unless you aqcuire a tool that periodically collects the data, I know of no way to review blocking historically. In the past, I've written...

Which version of SQL Server are you running?

One more thing to check, look for running profiler traces. I have seen multiple occasions where runaway profiler traces have caused high CPU usage.

select * from sys.traces

john pan (10/31/2012)

---

Hello - I would like some help please on an issue I am having on a site. I have found a previous thread (http://www.sqlservercentral.com/Forums/Topic1165211-145-2.aspx).

I have managed...

scogeb (10/31/2012)

---

Cool article, thanks for posting it!

One of the main servers I deal with has CXPACKET waits of about...

Does anyone ever ask or get asked what ACID properties are? I've been asked that one a number of times by non-DBA's grasping for interview questions. Whenever I interview DBA...

Wo do it programatically be executing a post install script on every SQL Server installation. You can review the text of the sp_set_sqlagent_properties in MSDB for more details.

@jobhistory_max_rows...

There are two parameters to the sp_trace_create stored procedure that control this @options and @filecount

http://msdn.microsoft.com/en-us/library/ms190362.aspx

[ @options= ] option_value

Specifies the options...

1. After a trace is setup and active, does the trace need to be restared if the SQL Server is restarted or does the trace start automatically with the...