Viewing 15 posts - 3,271 through 3,285 (of 49,571 total)
fantom (4/11/2016)
Source and target editions are both enterprise.
Are you certain about that? Check @@version, check the installer for what edition it is.
The error message you posted indicates an edition...
April 11, 2016 at 7:54 am
ttdeveloper (4/11/2016)
This seems to be a big miss by MS.
No, it's not. Neither is the DB diagram being restricted to a DB showing a lack of forethought
The database is the...
April 11, 2016 at 7:54 am
Why Readuncommitted? Is incorrect data acceptable here?
Try changing the table variable to a temp table, see if that gets you any improvement.
Also see if you can get rid of those...
April 11, 2016 at 6:09 am
Can you attach a screenshot of the 'not available', as I'm not sure what you're looking at.
April 11, 2016 at 4:39 am
It's not going to affect your backup sizes. Backups only contain the data in the DB, not the empty space. A 500GB database containing 100GB of data would have a...
April 11, 2016 at 3:51 am
rohan1424 (4/11/2016)
Will try your suggestion .Checking on the test server will give me exact timelines and will help to lessen the impact on prod server. Thanks for your...
April 11, 2016 at 3:38 am
Yes, the allocated space will still be there. Why does that mean that you must shrink the file?
April 11, 2016 at 3:35 am
Do you have a clean backup and an unbroken chain of log backups since that full backup?
Repair's going to throw away at least one page of table Paid, as far...
April 11, 2016 at 2:39 am
Put the latest service pack on. There's no reason to be running RTM of SQL 2008 R2.
April 11, 2016 at 2:38 am
They clear the plan cache when changed, so don't do them during working hours.
April 11, 2016 at 2:37 am
The only thing that CXPacket alone tells you is that queries are running in parallel. Nothing more.
Increasing Cost threshold (it's not measured in seconds) is a good idea. Other...
April 10, 2016 at 6:41 am
TomThomson (4/9/2016)
For me, the restriction to SQL collations would have been a killer
The collation limitation's not documented, so I'm wondering if it's a bug (though whether a bug in the...
April 9, 2016 at 8:33 am
Jeff Moden (4/8/2016)
it sounds "perfect" for "audit-only" and other "WORM" tables such as closed invoice/invoice detail tables. In fact, MS advertises Stretch DB as just exactly that...
It's the foreign...
April 9, 2016 at 5:22 am
johnwalker10 (4/8/2016)
This problem could be an issue with the database page or a problem with the SQL Server engine when determining what the expected allocation unit should be.
It's a bug,...
April 9, 2016 at 5:18 am
Viewing 15 posts - 3,271 through 3,285 (of 49,571 total)