Reputation
868
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 16
Impact
~176k people reached

  • 0 posts edited
  • 1 helpful flag
  • 71 votes cast
Sep
1
awarded  Famous Question
Aug
11
asked CDC and datamodel updates, best methodology?
Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
Jul
16
awarded  Popular Question
Apr
14
awarded  Popular Question
Nov
19
revised Procedure permission issues with a SQL state query
added 173 characters in body
Nov
19
comment Procedure permission issues with a SQL state query
Thanks for the suggestion. This was actually among the first alternatives I was thinking, and what I'm still considering if there's no cleaner alternative. But in this case, I'd rather avoid granting the SQLAgentOperatorRole and instead just create a scheduled job which would pass the information to a few tables every 1-5 minutes or so, allowing the DBO user to read the data from there. But it just seems unnecessarily complex just to get the results off of a few simple queries. :/
Nov
19
asked Procedure permission issues with a SQL state query
Nov
7
awarded  Popular Question
Nov
7
awarded  Yearling
Oct
12
comment SQL Server stuck in single_user with auto_update_statistics_async on
Finally got this resolved and opened the DB for MULTI_USER. A colleague disabled all external connections to the DB from software, which were trying to get in as well. Apparently it was just a question of odds. When enough contenders were took out, my loop for trying to set the DB back to MULTI_USER finally got through. I guess this is one of those lessons one will never forget. Thanks a lot for the help Martin!
Oct
12
comment SQL Server stuck in single_user with auto_update_statistics_async on
Thanks for the migration and edits. So far I've been unable to find anything to offer any alternatives, other than taking the instance down entirely, removing the DB files, bringing it up, deleting the DB, and creating it again from backup. The problem is, that server hosts other important DB's too so this is rather a way too drastic measure for a single DB.
Oct
12
asked SQL Server stuck in single_user with auto_update_statistics_async on
Sep
24
awarded  Autobiographer
Sep
19
comment SQL Server 2008 - How did I solve the need to check the column definitions quickly?
Ah nice to know! This is the trouble with creating general scripts from the perspective of a single - albeit large - database. :)
Aug
27
comment Outer Apply vs Left Join Performance
Logically, APPLY is called for every row in the left hand side of the query. In reality though, the execution planner will decide how to handle it in the context of the entire query, so it can sometimes be very hard to know beforehand whether a join or an apply will prove the better option. Best to just try both, compare their execution plans, see if you can make any adjustments, and go with that.
Aug
19
answered Simple SQL Query
Aug
7
comment AlwaysOn Secondary Replica DB-size
Thanks for the quick answer! Apparently sp_spaceused / sp_helpdb showed the space usage correctly after all. What got me confused was comparing them to a slightly older copy of the DB, which contained more unused space amounting to the same total space used. That combined with my not understanding the filesystem .mdf timestamps got me properly confused. Thank you for your time!
Aug
7
accepted AlwaysOn Secondary Replica DB-size