Reputation
570
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8 25
Impact
~68k people reached

  • 0 posts edited
  • 3 helpful flags
  • 39 votes cast
2d
comment How to script permissions for all logins/users/tables/schemas
Good scripts Kenneth! sp_DBPermissions seems to return everything I need with the exception of "VIEW DEFINITION" that is granted to users on a database. No records are returned for those.
Apr
18
awarded  Popular Question
Apr
4
asked How to script permissions for all logins/users/tables/schemas
Apr
4
accepted What are all the ways an open transaction will rollback?
Feb
24
awarded  Popular Question
Nov
27
awarded  Famous Question
Nov
17
revised Query to get total time logged in per week
added 148 characters in body
Nov
16
asked Query to get total time logged in per week
Nov
10
comment When does an execution plan not show in sp_WhoIsActive?
@Kin I have verified with the vendor that they are using Hibernate 3.5
Nov
6
asked Consultants using old version of Hibernate ORM for new application - should I be concerned?
Nov
5
comment When does an execution plan not show in sp_WhoIsActive?
@Kin I think I do remember the vendor mentioning that a long time ago. The actual query shows random-looking aliases, like so: SELECT outpu686.OUTPUT_SEQ AS outpu686_1, outpu686.ACCOUNT AS outpu686_2 Would that be a good indicator of NHIBERNATE or similar ORM?
Nov
5
comment When does an execution plan not show in sp_WhoIsActive?
@TomV No, this is a custom 3rd party application provided by a small vendor.
Nov
5
asked When does an execution plan not show in sp_WhoIsActive?
Nov
2
revised What are all the ways an open transaction will rollback?
added 191 characters in body
Nov
2
asked What are all the ways an open transaction will rollback?
Oct
19
comment Why are SELECT queries in sleeping status holding open transactions
@AaronBertrand If I see that these sleeping processes are BLOCKING other processes, then there is an issue, isn't there? Also, shouldn't the open_tran_count column be 0 if these queries are actually complete and the connection is just being held open for connection pooling?
Sep
3
awarded  Popular Question
Aug
21
awarded  Good Question
Aug
19
awarded  Popular Question
Aug
4
awarded  Promoter