1,727 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 7 months
seen Aug 13 at 12:17

Oct
17
revised TSQL to find if server is listening on dynamic or static port
clarify title
Oct
17
suggested suggested 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?
Aug
8
answered What are the top 3 performance Issues that you encounter with your SQL Servers?
Aug
3
comment Empty strings in VARCHAR(MAX) consuming space which cannot be recovered
what is the value for large_value_types_out_of_row for the table in sys.tables?