Viewing 15 posts - 961 through 975 (of 49,552 total)
If they are sysadmin, there is nothing you can do. Someone who is a member of the sysadmin role has all permissions on the server, and nothing can be denied...
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
August 10, 2017 at 4:15 am
I've done edition upgrades with the DB engine, but not with Analysis Services or Reporting Services. I don't know how SSAS handles it.
Uninstall and reinstall is safer.
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
August 10, 2017 at 2:36 am
Before you disable CDC, find out why it's enabled. It may have a legit and important business use.
Check that the jobs related to CDC are running correctly.
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
August 10, 2017 at 2:33 am
I'd guess that time is to create the backup file (can't recall if it has to be zeroed out). It shouldn't be that slow though.
What's the IO subsystem...
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
August 10, 2017 at 2:32 am
Anyone want to help out here? No DBA, no SQL knowledge.
https://www.sqlservercentral.com/Forums/1890533/Just-new-to-SQL-server-error
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
August 10, 2017 at 1:46 am
Thank you for the quick reply.
I was definitely confusing LSN's and differential bases there....
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
August 8, 2017 at 6:12 am
No, you shouldn't make them sysadmin.
Can you script out the login, the user and all their permissions? There's probably a deny somewhere, or a missing permission.
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
August 8, 2017 at 5:30 am
I know that the copy only option on a Full backup doesn't update 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
August 8, 2017 at 5:27 am
Licensing is paperwork. The SQL instance doesn't know whether it's licensed or not, check with the people who buy your software licenses, see what SQL licenses you have, then compare...
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
August 8, 2017 at 3:47 am
Try without the nolock, see if you can reproduce it.
Nolock allows duplicate reads, in addition to dirty reads (and missed rows as well), so that's a probably cause...
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
August 7, 2017 at 7:42 am
It's a login failure
Login failed for user 'RESPONDER/administrator
For some reason, the login doesn't have access to the DB. Speak to your DBA to help 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
August 6, 2017 at 4:44 am
They're both terrible.
Shrinking the DB just shrinks all the files in it (including the log file)
Unless you expect the space freed up to not be used 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
August 6, 2017 at 4:42 am
Parse-time and binding errors occur before any portion of the code starts to execute, and hence can't be caught by try-catch.
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
August 4, 2017 at 9:43 am
Changing max server memory does flush the plan cache, so I'd recommend that you do it at a quiet time.
Drop it in small amounts.
The majority of SQL's...
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
August 4, 2017 at 9:27 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
August 4, 2017 at 8:54 am
Viewing 15 posts - 961 through 975 (of 49,552 total)