Viewing 15 posts - 781 through 795 (of 49,552 total)
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
September 14, 2017 at 12:09 pm
For me that's one reason to have sa as the DB owner. So that I won't have any cases where logins have more rights than their assigned permissions state.
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
September 13, 2017 at 12:42 pm
Ownership doesn't require logging in. It's just about what security principal is associated with the job (or DB, or other things that can be owned)
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
September 13, 2017 at 11:29 am
SQL Server will do its damnedest to pre-allocate all of the memory that...
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
September 13, 2017 at 11:28 am
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
September 12, 2017 at 1:38 pm
Have you tried?
Or tried a search? https://www.sqlskills.com/blogs/paul/disaster-recovery-101-backing-up-the-tail-of-the-log/
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
September 12, 2017 at 9:15 am
Restore from backups (full + log should get you back up with no data loss)
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
September 12, 2017 at 1:17 am
Is this a virtual machine, or physical?
If it's virtual, then you can assign fewer cores to it in the VM configuration.
If it's physical though, short of removing...
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
September 8, 2017 at 9:59 am
You can have error handling and transactions to roll back partial operations and still have it email 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
September 8, 2017 at 4:41 am
There's no magic value for PLE that's good.
In general, you want it as high as possible. Consider that it's a measure of how much churn there is in...
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
September 7, 2017 at 2:53 pm
Use the ALTER DATABASE ... MODIFY FILE option for moving the files, and note that once you take the DB offline you need to move the files manually, SQL won't...
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
September 7, 2017 at 11:57 am
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
September 7, 2017 at 11:53 am
Yup. Normal behaviour. Most errors terminate the statement, not the batch.
If that's not what you want, you need some error handling, and probably some transactions. Gail Shaw
http://www.sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We stand on the bridge and no one may pass
September 7, 2017 at 11:47 am
FROM tblFund_Transaction FT (INDEX = indFundTxn_DateCommitted)
In both places where that appears, you need a WITH added (or, probably better to take the index hint out)
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
September 7, 2017 at 9:04 am
It's got to read every single page in that 700GB database, and do a bunch of checks to make sure all the pages are correct, all the DB structures are...
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
September 7, 2017 at 9:01 am
Viewing 15 posts - 781 through 795 (of 49,552 total)