Viewing 15 posts - 3,271 through 3,285 (of 49,552 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...
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
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...
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
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...
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
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.
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
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...
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
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...
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
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?
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
April 11, 2016 at 3:35 am
Why do you need to shrink the files?
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
April 11, 2016 at 3:13 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...
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
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.
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
April 11, 2016 at 2:38 am
They clear the plan cache when changed, so don't do them during working hours.
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
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...
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
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...
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
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...
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
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,...
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
April 9, 2016 at 5:18 am
Viewing 15 posts - 3,271 through 3,285 (of 49,552 total)