Reputation
19,139
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
9 45 92
Impact
~676k people reached

12h
comment Does this simple database design work even if it's cyclic?
@Vérace - you should add that as an answer.
1d
comment Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command
I'm unsure of the technical specifics but third party backup tools implement different compression schemes that appear to work at the server.
1d
comment Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command
Native backup compression, or some CLR-based filter compression, is useful since it reduces the write I/O. RAR'ing the backup after it has taken place is likely just making restore more difficult.
1d
answered Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command
1d
comment Add autoincrement to existing PK
When you say "autoincrement" what exactly are you referring to? In SQL Server there is no such property for a column. Do you mean IDENTITY?
1d
comment Transaction Log Backups Serial or Parallel?
just FYI, I haven't voted to close it.
1d
comment Transaction Log Backups Serial or Parallel?
I'm thinking this might be very close to VtC as "opinion based"
1d
comment Transaction Log Backups Serial or Parallel?
I lean towards a job per database since it's more manageable that way, but then I'm a "control freak", or so I've been told... Maybe you have one database that can stand 15 minutes of data loss, but another that can only have 5 minutes, just for starters.
1d
revised sp-askbrent wiki description
added 517 characters in body
1d
revised sp-askbrent wiki excerpt
added 131 characters in body
1d
comment Check for impersonated users using Policy Management
when you say "impersonated users", are you talking about currently logged-in processes that are impersonating users?
1d
reviewed No Action Needed SQL Server Transactional Replication Not Being Created
1d
revised How can I intentionally grow my transaction log to 500GB for testing purposes?
added 23 characters in body; edited title
1d
wiki created sp-askbrent description
1d
wiki created sp-askbrent excerpt
1d
suggested approved edit on sp-askbrent tag wiki
1d
suggested approved edit on sp-askbrent tag wiki excerpt
1d
revised How to export the output of sp_AskBrent?
edited tags
2d
reviewed Reviewed SQL AlwaysOn & System Center Configuration Manager TP 4 1601
2d
revised SQL AlwaysOn & System Center Configuration Manager TP 4 1601
edited tags