Viewing 15 posts - 43,516 through 43,530 (of 49,571 total)
Is RB_TABLE a heap by any chance? If so, it'll have no stats that could be updated.
October 28, 2008 at 2:27 am
lyletan (10/27/2008)
The message is:
Could not continue scan with NOLOCK due to data movement.
Server: Msg 601, Level 12, State 1, Line 1
Could not continue scan with NOLOCK...
October 28, 2008 at 2:22 am
makjain (10/27/2008)
...
October 28, 2008 at 2:21 am
Jeffrey Williams (10/27/2008)
The following example changes the compression of a nonpartitioned table. The heap or clustered index will be rebuilt. If the table is a heap, all nonclustered indexes will...
October 27, 2008 at 4:03 pm
DBA (10/27/2008)
October 27, 2008 at 3:37 pm
Yup. It's documented in Books Online under < drum roll > Alter Table .:D
REBUILD
Use the REBUILD WITH syntax to rebuild an entire table including all the partitions in a partitioned...
October 27, 2008 at 3:09 pm
Please don't put questions into the thread title. It gets cut off.
What's the question?
October 27, 2008 at 3:05 pm
Leo (10/27/2008)
How do I check of bad stats? Do you have any command line to check the table?
It's not a command. It's a case of noticing queries that run well...
October 27, 2008 at 3:03 pm
Chris (10/27/2008)
select isnumeric('3edf2') when i tried this it showing as 0 ...wats the reason for this
3edf2 cannot be cast to any of the numeric data types. It is not a...
October 27, 2008 at 2:44 pm
Good point.
The other reason to run checkDB is that on SQL 2000 checkDB did not include checkcatalog, which is why we so often see checkDB errors about inconsistent metadata...
October 27, 2008 at 2:39 pm
oscar (10/27/2008)
Is it a simple step by step process? or a mini/delicate project?
Look up Database Mirroring in Books Online. It's not too complex, but it's not a 2-click process....
October 27, 2008 at 2:14 pm
I got an answer from one of the storage engine team. He said that at some point in time, there must have been rows on all of those pages, even...
October 27, 2008 at 2:02 pm
A view doesn't store data. It's just a saved select statement. When you query a view, part of the parsing and binding that occurs replaces the view's name with the...
October 27, 2008 at 1:32 pm
george sibbald (10/27/2008)
Dan mentioned experts-exchange, no tech site annoys me like that one
I used to post there occasionally, before they became a paying site. At the time people gained points...
October 27, 2008 at 1:15 pm
Roy Ernest (10/27/2008)
Now the question is why does not get cleaned up?
If/when I find out, I'll be sure to let you know.
October 27, 2008 at 1:05 pm
Viewing 15 posts - 43,516 through 43,530 (of 49,571 total)