Viewing 15 posts - 39,226 through 39,240 (of 49,571 total)
Please post udf and the exec plans (from both the VM and the prod box), as well as table defs and index defs.
May 10, 2009 at 8:34 am
Paul White (5/10/2009)
GilaMonster (5/10/2009)
You are correct in that conclusion.Can you provide anything authoritative to support that?
I am intrigued.
Itzik Ben-Gan mentioned it during his precon at PASS last year. He also...
May 10, 2009 at 6:45 am
Swayambhu narayan Samamtroy (5/10/2009)
Run DBCC Checkdb and post what is the message you are getting
He already has. See the third post in this thread.
May 10, 2009 at 6:34 am
The mdf file contains the data, the metadata, any indexes. The ldf file is the transaction log, a list of changes to data pages.
Have a read through this: http://msdn.microsoft.com/en-us/library/ms179316.aspx
May 10, 2009 at 3:44 am
RBarryYoung (5/9/2009)
May 10, 2009 at 3:33 am
Just run it with no parameters in the database in question.
May 10, 2009 at 3:31 am
Please run the following on that database and post the full results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
May 9, 2009 at 2:04 pm
Florian Reischl (5/9/2009)
May 9, 2009 at 2:03 pm
WayneS (5/8/2009)
So, if this is done, why is it still doing an index scan and rid lookup instead of an index seek? What am I missing?
Which operator in which...
May 9, 2009 at 2:36 am
Don't try. The system databases shouldn't be moved from one version to another. It's really asking for problems.
Script out whatever it is in the master database that you want (logins,...
May 9, 2009 at 2:12 am
Jeffrey Williams (5/8/2009)
May 9, 2009 at 2:06 am
RBarryYoung (5/8/2009)
May 8, 2009 at 1:50 pm
Marios Philippopoulos (5/8/2009)
It would have been great if SQL Server stored that extra run-time info as well, the same way it stores the "estimated" data.
It does with some, in a...
May 8, 2009 at 1:47 pm
Lowell (5/8/2009)
May 8, 2009 at 9:50 am
Frank Buchan (5/8/2009)
May 8, 2009 at 9:32 am
Viewing 15 posts - 39,226 through 39,240 (of 49,571 total)