435 reputation
211
bio website
location United States
age
visits member for 2 years, 9 months
seen Oct 22 at 8:57

Oct
2
comment SQL Server: Clarity on which service user does what (backups, etc) RE accessing network shares
thanks! That is going to require a restart of SQL if I change the pw.... ack!
Oct
2
comment SQL Server: Clarity on which service user does what (backups, etc) RE accessing network shares
Thanks! AD is not avail to me. OP revised.
Oct
2
revised SQL Server: Clarity on which service user does what (backups, etc) RE accessing network shares
added 105 characters in body
Oct
2
asked SQL Server: Clarity on which service user does what (backups, etc) RE accessing network shares
Sep
28
revised Index maintenance operations that are ONLINE in Standard Edition: Is table Read-Write or Read-Only?
added 38 characters in body
Sep
24
accepted Index maintenance operations that are ONLINE in Standard Edition: Is table Read-Write or Read-Only?
Sep
24
asked Index maintenance operations that are ONLINE in Standard Edition: Is table Read-Write or Read-Only?
Sep
23
comment Measure fragmentation of a single index?
@AaronBertrand I dug around google, SE etc and did not find a direct way to see fragmentation of a single non clustered index. I may be missing something obvious, but I am looking (and not finding)
Sep
23
comment Measure fragmentation of a single index?
OK, give me the benefit of the doubt here. I really do need to defrag. My tables are large (50-150 GB each), and my indexes don't fit into RAM. Now that we have that out of the way, if Ola's tool answers the question, I will give it a try!
Sep
23
asked Measure fragmentation of a single index?
Jul
31
accepted SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?
Jul
31
comment SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?
Can I just switch the existing NORECOVERY to STANDBY on the fly and all will be OK?
Jul
31
comment SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?
Availability groups is something I would love (and pay for), but the dependence on Windows domains and OS related dependencies makes availability groups unfeasible for us. We will be on log shipping forever (at least until avail groups can be managed purely within sql, like setting up mirroring... We don't use mirroring because it does not support one-->many replication)
Jul
31
asked SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?
Jul
2
awarded  Curious
May
15
awarded  Yearling
May
14
comment SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables
@StevePettifer Thanks. OP enhanced. (seems really strange that an up the middle dba question like this would be put on hold.) Note you can vote to reopen, and can also hit "flag" asking the sysops to reconsider.
May
14
revised SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables
enhanced the presentation and phrasing
May
14
revised SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables
added 67 characters in body
May
13
revised SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables
added 180 characters in body