428 reputation
211
bio website
location United States
age
visits member for 2 years, 7 months
seen Sep 12 at 3:54

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?
Dec
19
comment How to archive a transactional table on another server?
Thanks! I am a tad wary of transactional replication, because it sounds hairy (brentozar.com/archive/2013/09/… ). Can you even do a two-box implementation of transactional replication, or is it reqd to do 3 box?
Dec
19
revised How to archive a transactional table on another server?
added 81 characters in body
Dec
18
comment How to archive a transactional table on another server?
@ThomasStringer Yes, we want the archive table to include (keep) data that was deleted on prod. OP updated.
Dec
18
revised How to archive a transactional table on another server?
added 234 characters in body
Dec
18
comment How to archive a transactional table on another server?
@Kin OP enhanced
Dec
18
revised How to archive a transactional table on another server?
added 107 characters in body