Viewing 15 posts - 42,271 through 42,285 (of 49,566 total)
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
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...
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...
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...
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...
December 18, 2008 at 11:16 am
rew (12/18/2008)
Hi AllWhen I do "Index REBUILDs", my database files GROW. Alot! And the database is in "SIMPLE" recovery mode.
Yup. They will. Rebuilds are logged operations (though bulk logged in...
December 18, 2008 at 11:04 am
Viewing 15 posts - 42,271 through 42,285 (of 49,566 total)