435 reputation
211
bio website
location United States
age
visits member for 2 years, 8 months
seen yesterday

2d
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
May
9
asked SQL Server: TSQL or safe steps needed: Change collation en masse for group of tables
Jan
9
comment Which SQL standard is most broadly and completely supported?
@AaronBertrand Standard SQL is heavily used by a large % of developers. There are platform specific functions and tweaks, but the vast majority of work done (on MySQL, SQL Server, etc) is plain jane SQL. gbn says not to bother, then says to play with MySQL. Is that useful?
Jan
9
comment Which SQL standard is most broadly and completely supported?
"Standard SQL isn't used in the real world for paying jobs on successful projects..." -- silliest thing posted on all of stack exchange.
Jan
5
accepted SQL Server 2008: Measure tps / select statements per second for a specific table?