Viewing 15 posts - 42,271 through 42,285 (of 49,571 total)
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
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic622591-9-1.aspx
December 19, 2008 at 12:17 am
suresh.maddali (12/18/2008)
December 19, 2008 at 12:02 am
Krishna_DBA (12/18/2008)
3. when does the commited data in the log files move to data file.Well, when a checkpoint occurs. Checkpoint writes all dirty pages to the disk.
The lazy writer also...
December 19, 2008 at 12:01 am
paul.corujo (12/18/2008)
Excuse my ignorance but doesn't it say 64 bit Enterprise edition with service pack 2?
Yes, but that's not referring to SQL.
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) ...
December 18, 2008 at 3:01 pm
paul.corujo (12/18/2008)
Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
You have 2005 RTM there. Mirroring was only enabled in SP1.
December 18, 2008 at 2:35 pm
They're created by someone adding a second (or third or forth, ...) data file to the database. Only the primary file has the extension mdf. All other data files are...
December 18, 2008 at 2:29 pm
Matt Miller (12/18/2008)
I'll take care of the French questions if you get stuck.
Aragato Gozimasta
With the french question, it wasn't so much the question. The OP translated into passable...
December 18, 2008 at 1:45 pm
Viewing 15 posts - 42,271 through 42,285 (of 49,571 total)