Reputation
1,795
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 10
Newest
 Nice Answer
Impact
~150k people reached

Oct
27
comment Can I Simply Change A Transaction Log From Unrestricted to Restricted?
and don't forget to add a log backup job.
Oct
21
comment SQL Server 2008 R2 “Ghost Memory”?
The only time I'd be concerned is when my sql server is using LESS than 82%!
Oct
17
revised TSQL to find if server is listening on dynamic or static port
clarify title
Oct
17
suggested approved edit on TSQL to find if server is listening on dynamic or static port
Oct
15
comment Why is query using Clustered Index when it shouldn't?
I agree, I didn't notice the column specs, I just cringe everytime I see SELECT * ! Obviously INCLUDEd columns in the index would have the same effect as well.
Oct
13
answered Why is query using Clustered Index when it shouldn't?
Oct
4
comment SSIS flat file manager - skips the last record
@flybyte Make sure you have all the latest service packs installed?
Oct
3
answered Scheduled backup task doesn't always backup all databases despite always saying job successful
Sep
25
answered SSIS flat file manager - skips the last record
Sep
16
answered ON DUPLICATE KEY UPDATE question
Sep
9
comment How to measure the number of database writes on SQL Server 2008 R2
@robert are you looking for all tables, or just specific ones?
Sep
9
comment Replication slows down on massive deletes
Are there any triggers on the table? Any cascaded deletes?
Sep
1
answered Will creating partitions reduce locking and how do we implement this in sql-server?
Aug
30
answered Things to consider with a bigger table
Aug
19
comment What is blocking and how does it happen?
Thanks for not going into the details of what happens to the losing child in the deadlock situation! :) +1
Aug
11
awarded  Commentator
Aug
11
comment sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?
@Andrew Updated with sample code
Aug
11
revised sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?
added 214 characters in body
Aug
9
comment Adding columns to production tables
+1 on the backup. and make sure you have enough log space too.
Aug
9
answered sp_repladdcolumn - is it possible to supply a list of Publications to add this column on?