Viewing 15 posts - 42,256 through 42,270 (of 49,563 total)
Perry Whittle (12/19/2008)
assuming it is released quick enough
Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim, unless...
December 19, 2008 at 7:05 am
Backup the database
Copy the backup file to the other server
Restore the backup.
December 19, 2008 at 7:01 am
Russell.Taylor (12/19/2008)
December 19, 2008 at 7:00 am
Chris Morris (12/19/2008)
It's a longshot, but have you tried putting this little lot into a sproc and running the results into a prepared table?CREATE TABLE...
INSERT INTO ... EXEC ...
That's very...
December 19, 2008 at 6:59 am
Swirl80 (12/19/2008)
out of curiosity, from a performance point of view, which is better:
As I said above, they are identical in meaning and in effect.
Neither is desired for performance reasons. If...
December 19, 2008 at 6:52 am
Perry Whittle (12/19/2008)
just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt.
Lock pages just means that the...
December 19, 2008 at 6:52 am
When you create the job step, set the type to OS command. They type in the OS commands that you need.
December 19, 2008 at 3:23 am
Mani (12/18/2008)
December 19, 2008 at 3:12 am
nKognito (12/19/2008)
Understood. But what 2nd one will do at the end of 1nd? Will update the next record that matches to the condition or will not do anything?
It will update...
December 19, 2008 at 3:11 am
I'm not sure I understand. Please can you post table structure (as create), sample data (as inserts) and your desired output. Read this to see the best way to post...
December 19, 2008 at 12:53 am
Why would (3) lead to a deadlock?
Have you read through the sections in Books Online on locking?
December 19, 2008 at 12:52 am
nKognito (12/19/2008)
Thanks for your help, but I know where deadlock occures.
Are you sure? You know what the victim is, but without the deadlock graph there's no way to be...
December 19, 2008 at 12:50 am
Can you obtain and post a deadlock graph? Switch traceflag 1204 on (DBCC TRACEON (1204,-1)). That will print the deadlock graph into the error log, showing the resources and queries...
December 19, 2008 at 12:25 am
In the alter, the function's called [FN_R2CQ], but you're calling it as dbo.QTR_AMOUNT. Cut and paste issue?
Aside, but also important, that is not going to perform particularly well, especially if...
December 19, 2008 at 12:23 am
Books Online?
Not joking, it's what I used for the beta exams.
December 19, 2008 at 12:21 am
Viewing 15 posts - 42,256 through 42,270 (of 49,563 total)