Viewing 15 posts - 181 through 195 (of 49,552 total)
Should do, but it'll depend on exactly how the query is sent.
Usually I see stuff like this
(@P1 int) @P1 = 27; SELECT Stuff FROM Table WHERE Column...
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 17, 2018 at 4:00 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
April 17, 2018 at 3:53 am
Now My question is why I am not able to shrink the log 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 17, 2018 at 3:51 am
Capture the event rpc_completed.
Batch completed is for ad-hoc batches, like what you run from Management Studio. It won't catch remote procedure calls, which is how applications send parameterised...
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 17, 2018 at 3:48 am
Database level permissions cannot be granted to a server role.
Server roles get the server-level permissions (VIEW SERVER STATE, ALTER ANY LOGIN, etc)
Database roles get database level permissions (SELECT,...
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 17, 2018 at 3:45 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
April 16, 2018 at 7:44 am
That's not the system view sys.objects. Whatever that it, it's in the dbo schema and it's a user table. So, no idea, it's something of yours.Check with your developers, see...
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 16, 2018 at 7:41 am
hurricaneDBA - Monday, April 16, 2018 1:50 AMSome of the results which could be troublesome:GRANT EXECUTE sys sp_srvrolepermission
GRANT EXECUTE sys sp_sqlagent_start_job
GRANT EXECUTE sys sp_sqlagent_stop_job
GRANT EXECUTE sys sp_revokedbaccess
Create yourself a user with no permissions 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
April 16, 2018 at 1:59 am
btw, I see 176 permissions granted to Public in a new SQL 2017 database. Not >2000. Could be that someone's granted extra permissions to public in your DB?
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 16, 2018 at 1:39 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
April 16, 2018 at 1:37 am
Most likely the problem is in the asp.net app that's being used to transfer the data. If it's doing it a row at a time, it will be slow 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
April 15, 2018 at 3:52 pm
From that page:
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which...
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 15, 2018 at 3:51 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
April 12, 2018 at 1:05 pm
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 12, 2018 at 1:05 pm
If you did not have something monitoring what was running at that time, then you will no be able to tell what was running at the time.
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 12, 2018 at 11:37 am
Viewing 15 posts - 181 through 195 (of 49,552 total)