Viewing 15 posts - 11,071 through 11,085 (of 49,552 total)
Jeff Moden (11/4/2013)
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
November 4, 2013 at 11:35 pm
Are you sure it failed because of the compat level of the publisher?
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
November 4, 2013 at 9:47 pm
Possibly large amount of log being included in the backup. Guessing though.
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
November 4, 2013 at 2:15 pm
Are you appending multiple backups to the same file? If you back up repeatedly to the same file that's the default, append.
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
November 4, 2013 at 1:45 pm
You've got to set Veeam to not backup and truncate the transaction logs, that or stop log shipping and use something like mirroring or availability groups. There's got to be...
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
November 4, 2013 at 1:43 pm
Backups don't include unallocated pages. Shrink will just re-fragment all your indexes.
Did you rebuild the clustered index for that table? Does it have a clustered index?
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
November 4, 2013 at 12:22 pm
Locking isn't by default at the row level. It depends how much data you're retrieving. SQL can choose to lock at the row level, page level or table level.
Did you...
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
November 4, 2013 at 10:01 am
ROW_NUMBER() OVER (partition by ac_id order by Rev_no DESC) as RevisionNumber
Then filter for that = 1.
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
November 4, 2013 at 5:50 am
It's mostly cases where the parsing rules have been tightened. Don't know if there's a list. It's why you need to run upgrade advisor and run tests before upgrading anything.
For...
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
November 4, 2013 at 5:13 am
Why not use backup/restore? Far less hassle than a copy job, much less impact on production (you can just use the previous night's production backup) and probably faster.
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
November 4, 2013 at 4:08 am
If you want to make a copy of the DB, why not just take a backup and restore the backup as a new database?
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
November 4, 2013 at 3:48 am
Not necessarily, no. In most cases, but there are changes that don't fall under the compat modes
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
November 4, 2013 at 3:47 am
kevaburg (11/4/2013)
Just to clarify.....In SIMPLE recovery mode, transactions are cleared once they are committed,
In simple recovery, the log is marked reusable by a checkpoint, not a commit. That's assuming 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
November 4, 2013 at 3:02 am
Could you be a little more specific about what you want to collect, when and how?
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
November 4, 2013 at 2:48 am
Check with the vendor. Some will say yes, some will refuse support if @@version doesn't match what they support. I've even seen one that checked the product major version and...
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
November 4, 2013 at 2:46 am
Viewing 15 posts - 11,071 through 11,085 (of 49,552 total)