Viewing 15 posts - 2,191 through 2,205 (of 3,232 total)
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...
July 26, 2007 at 3:57 pm
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)))
July 26, 2007 at 3:54 pm
What happens if you run the SELECT portion of the SP manually through Query Analyzer?
July 26, 2007 at 3:20 pm
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. ...
July 24, 2007 at 2:59 pm
How many rows are in your Design_Details table? Is you rFK column in the Design_Details table indexed?
July 20, 2007 at 2:29 pm
How many rows are in your table? Can you post your table and index DDL?
July 20, 2007 at 1:29 pm
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...
July 20, 2007 at 1:26 pm
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...
July 20, 2007 at 10:17 am
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...
July 19, 2007 at 4:05 pm
Keep in mind that if the SomeColumnName LIKE '%' + @ParameterName + '%' is the only criteria in your where clause, this will result in a table scan.
July 19, 2007 at 9:10 am
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...
July 18, 2007 at 2:42 pm
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...
July 13, 2007 at 10:38 am
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...
July 13, 2007 at 9:40 am
Yes. If SQL Server encounters a deadlock, the detailed info. will get written to the log file.
July 12, 2007 at 12:01 pm
Viewing 15 posts - 2,191 through 2,205 (of 3,232 total)