Reputation
4,724
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 17 42
Newest
 Caucus
Impact
~452k people reached

1d
awarded  Caucus
Jul
22
reviewed Approve Two select in one query
Jul
21
reviewed Approve mysql trigger / stored procedure - update another table row by row
Jul
18
comment Slow fill database
If you add more memory to the system, SQL will automatically increase the size of the cache.
Jul
15
answered Slow fill database
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