465 reputation
212
bio website
location United States
age
visits member for 2 years, 10 months
seen Dec 1 at 21:30

Nov
21
awarded  Popular Question
Nov
5
asked sp_helpdb — returns nothing, because db is restoring (log shipping target) SQL Server
Oct
29
accepted Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
Oct
29
revised Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
added 500 characters in body
Oct
29
comment Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
@ypercube OP enhanced. We have no order by because we did not think it needed (and when getting all rows, order by is not needed). Is order by required when doing paging?
Oct
29
revised Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
added 260 characters in body
Oct
29
asked Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
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)