Reputation
4,704
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 17 41
Impact
~433k people reached

Jun
23
comment How can I add a rowversion column to a large table with minimal downtime
@BrentOzar, do you have a recommended method to avoid the triggers firing when the data is being migrated in batches?
Jun
15
comment Query for total downtime of site using datestamps and status columns
Please explain your definition of "Site". Also, where are you pulling these dates from? You need to add more tags as well, as SQL is too broad.
Jun
11
comment Full backup at 1am, not started by my maintenace plan
Some virtual server backup software will issue a full database backup after the snapshot. We had this happen, and it interfered with an emergency point in time recovery. We had easy access to our regular scheduled full backup, and all the transaction logs, but this mysterious full backup was off on a tape somewhere, which took a few extra hours of explain to the ops team that we needed it.
Jun
10
reviewed Approve How to prevent #Error values derived from Nulls in an outer join
Jun
10
awarded  Famous Question
Jun
4
reviewed Approve select members with the longest running absence streak
Jun
1
awarded  Excavator
Jun
1
comment Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?
I highly recommend using the batch_size parameter on large tables. This will cause the command to run in a series of transactions as opposed to one giant transaction.
Jun
1
revised Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?
Added a link to msdn for DBCC CLEANTABLE
May
28
comment Periodically update a table with new records from another server
@chipples, see my note in the answer.
May
28
revised Periodically update a table with new records from another server
added 337 characters in body
May
26
comment Periodically update a table with new records from another server
If the record is inserted or updated since the last time your process reviewed the table, you will grab it. If there are records currently being updated, they will block the process until the transaction is complete (assuming read-committed).
May
25
reviewed Close How to make sqlplus more user-friendly anyone?
May
25
reviewed Leave Open Recover master database
May
25
reviewed Leave Open SQL Server Disk IO Performace appears different between otherwise identical servers
May
25
reviewed Approve How do you version your Oracle database changes?
May
22
comment Split database to fit on SSDs
If you are paying for Enterprise edition ($$$) why on earth are you trying to save money on drives? Spend a few thousand dollars and build a decent raid.
May
22
comment Transaction log backup file larger than expected?
The first thing I do on any server I take over is change the model database properties to grow the database and log files in 64 or 128MB chunks instead of the default 10%. Those default settings have been around for 15 years or more, and are quite ridiculous in my opinion.
May
22
answered Periodically update a table with new records from another server
May
22
reviewed No Action Needed database Compatibility 90 to 100 changing causes any problem