This may get you going in the right direction.  Keep in mind that in the event you have 2 rows in your table with the same MAX(Date), you'll get more...

You either need to combine the logic into one single trigger, or use the IF UPDATE() logic within your triggers.  What is happening here is that your triggers are recursively...

Either run SET QUOTED_IDENTIFIER OFF and re-create your SP, or change your REPLACE statement to look like this:

replace(c.coursetitle, char(39), (char(39) + char(39)))

What happens if you run the SELECT portion of the SP manually through Query Analyzer?

http://www.sqlservercentral.com/columnists/gsmilevski/anefficientsetbasedsolutionforislandsandgaps.asp

I think we need more info here.  How do you know it is even I/O delays?  It could be due to prolonged blocking from long transactions or poorly written queries. ...

How many rows are in your Design_Details table? Is you rFK column in the Design_Details table indexed? 

How many rows are in your table?  Can you post your table and index DDL?

David's advice is good.  I would start by checking the Archive bit for index first.  My guess is that this column is not indexed and as David said, SQL Server...

Just to expand on what Steve has said, separate LUNs do not always mean separate physical disks.  Many SAN administrators don't understand that a database server requires separation at...

Brian's function should work here.  Here's an example of how ( I tweaked his original to include a join on the ItemNum column and to use my example data column...

Keep in mind that if the SomeColumnName LIKE '%' + @ParameterName + '%' is the only criteria in your where clause, this will result in a table scan.

Ali,

Go to the forums main page: http://www.sqlservercentral.com/forums/default.aspx.  Select the forum that you with to post in.  You will then see a 'New Thread' button on the upper left...

Yes, table, view, and index DDL will help.  Also, you say there are no parameterized queries in SQL Server.  What do you mean by that?  Of course you can use...

Your best bet here really is to run a test of your own as Sergiy and Vladan have stated.  While you may find sources that say that it may or...