Viewing 15 posts - 2,206 through 2,220 (of 3,232 total)
I think its a bit late to find out what processes contributed to your deadlock situation, but you can enable trace flags 1204 and 3604 so that you can capture...
July 12, 2007 at 11:40 am
Yes, as Sergiy suggests a view would be your best bet. If you must continue with updating the count column there's no need for a cursor or a temp table. ...
July 11, 2007 at 4:33 pm
Well, the reason for your query taking so long is because you've written a cursor to handle a task where it is clearly not needed. This can be sped up...
July 2, 2007 at 3:48 pm
I've mostly only worked with light backgrounds; however, when I was a UNIX admin, I would use a red background with white lettering for my production boxes. This helped remind...
June 29, 2007 at 12:40 pm
We've been using Red Gate for quite some time now (maybe forever now that I think about it) and it is a product that I use almost daily. We are...
June 29, 2007 at 11:05 am
Hey, no arguement here. I was just looking for an explanation on your position. 'Nuff said.
June 28, 2007 at 1:54 pm
If the 2 queries create the same query plan and return the same results (which in this case they should), what does the system requirements have to do with it? ...
June 28, 2007 at 12:13 pm
I prefer the second method over the first as the second method is the ANSI standard JOIN. In looking at your second statement, your LEFT JOIN should be an INNER JOIN. ...
June 28, 2007 at 9:16 am
What security context is the job running under? Does it have permissions to insert into your table? I would set up a mock job to do a simple INSERT into...
June 22, 2007 at 4:13 pm
It seems like we are missing part of the story here. JC, there is obviously more code than what you've posted here. Can you post your code? What is happening...
June 22, 2007 at 4:01 pm
Another thing Ryan, correlated sub queries are usually poor performers and can be re-written using JOINs or derived tables. I would be careful with taking any approach involving correlated sub...
June 22, 2007 at 3:49 pm
Just curious, but what is the purpose of UNIONing NULL values into your result set?
June 22, 2007 at 2:02 pm
Well it appears that he just wants the last 3 orders by date for that specific customer and then wants to be able to UNION that in with another result...
June 22, 2007 at 1:16 pm
JLK - you are absolutely correct. I apologize for my hasty posting. As I stated, I did not test the code I posted; moreover, I did really read it to...
June 22, 2007 at 12:59 pm
JOINing a derived table in place of the IN clause should do the trick. Try this (and keep in mind I haven't tested it):
SELECT NULL CompanyName, NULL OrderDate
UNION ALL
SELECT...
June 22, 2007 at 12:27 pm
Viewing 15 posts - 2,206 through 2,220 (of 3,232 total)