Viewing 15 posts - 19,756 through 19,770 (of 26,490 total)
maxyogesh2002 (7/17/2009)
Dear Friends,I m attached the JPEG of my Execution plan plz tell me Whats the problem in that query
why its taken lot of time to update.
First, I'd recommend...
July 17, 2009 at 10:57 am
jcrawf02 (7/17/2009)
Lynn Pettis (7/17/2009)[hr
So, what's stopping you from getting back out there? I'm sure that you could be used and abused just like the rest of us. It...
July 17, 2009 at 10:53 am
First, remember that no all errors can be trapped in in a TRY/CATCH setup.
Code your trigger to use TRY/CATCH. For the errors that can be caught, capture the error...
July 17, 2009 at 10:39 am
Just realize that it may not take all 14 GB of RAM. Not saying I wouldn't set the maximum memory available to SQL Server, I would; but the best...
July 17, 2009 at 10:33 am
jcrawf02 (7/17/2009)
Lynn Pettis (7/17/2009)
July 17, 2009 at 10:04 am
rob (7/17/2009)
July 17, 2009 at 10:02 am
jcrawf02 (7/17/2009)
Lynn Pettis (7/17/2009)
July 17, 2009 at 9:58 am
I have to agree with Brandie, obviously SQL Server doesn't need all of the available memory or it would take it, potentially starving the OS if it needed all of...
July 17, 2009 at 9:07 am
Short of a backup file, I know of no way to recover a database that has been dropped.
Why don't you have a backup of a production database? Setting up...
July 17, 2009 at 9:04 am
I was also looking at your code, what version of SQL Server are using? I'm guessing that it is SQL Server 2000, not SQL Server 2005. If it...
July 17, 2009 at 9:00 am
Blazix Marler (7/17/2009)
But query is taking lot of time to run , can it be tuned to run more faster.The query is
select s.domainid,d.domain,s.urlid,u.url,s.applicationargumentid,a.application_argument
from...
July 17, 2009 at 8:58 am
rob (7/17/2009)
July 17, 2009 at 8:43 am
You still haven't answered Brandie's question. Are you having performance issues or are you just wondering why the extra 1.5 GB of RAM isn't getting used?
July 17, 2009 at 8:35 am
jcrawf02 (7/17/2009)
Lynn Pettis (7/16/2009)
July 17, 2009 at 8:32 am
Maxer (7/17/2009)
After that it gets a BIT fuzzy.
Say...
July 17, 2009 at 8:03 am
Viewing 15 posts - 19,756 through 19,770 (of 26,490 total)