Viewing 15 posts - 42,256 through 42,270 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2008 at 12:23 am
Books Online?
Not joking, it's what I used for the beta exams.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2008 at 12:17 am
suresh.maddali (12/18/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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) ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 1:45 pm
paul.kuczwara (12/18/2008)
Is it possible to attach the DB even though it is looking for three NDF files?
No. Those are secondary data files, ie they contain part of the data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 1:35 pm
bitbucket (12/18/2008)
I give up ? What is it in U.S. English
Hoekom nie? Ek het eek vraag in Fraans geseen. Nie maklik to antwoord nie.
Why not? I've seen one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 1:16 pm
clementhuge (12/18/2008)
grea answer! This is a good news. I never thoughtI can do a snapshot on a database "in-recovery".
In general you can't. It only works for a mirrored database that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 12:10 pm
clementhuge (12/18/2008)
When ou talk about snapshot, are you considering snapshots on mirrored databases ? because the mirrored databases are in recovery state, so I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 11:16 am
Viewing 15 posts - 42,256 through 42,270 (of 49,552 total)