Reputation
773
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 12 32
Impact
~121k people reached

Apr
18
comment Identifying rows which don't match a master row
@AaronBertrand nvarchars and ints, with some odds and ends like datetimes. Could be anything, multiple tables actually.
Apr
18
comment Identifying rows which don't match a master row
Impressive, I would have never even thought to do this. Toying with this now
Apr
18
comment Identifying rows which don't match a master row
I'm only looking to query these servers and update 4 times a day right now so it shouldn't be a big deal. Querying 40 servers, half with Ping > 2000ms CPU/I/O speed is never the bottleneck...
Apr
18
comment Identifying rows which don't match a master row
Hm never used hash before, that sounds perfect. I'll see if I can make it work
Apr
18
revised Identifying rows which don't match a master row
added 259 characters in body
Apr
18
revised Identifying rows which don't match a master row
added 504 characters in body
Apr
18
accepted Select a single row from two distinct columns
Apr
18
accepted Top 2 rows per partition from an absolute value date difference
Apr
18
asked Identifying rows which don't match a master row
Apr
1
revised Upgrade process from SQL Server 2000 to SQL Server 2012
improved syntax but I still have no idea what this is trying to say...
Apr
1
suggested approved edit on Upgrade process from SQL Server 2000 to SQL Server 2012
Mar
7
comment Splitting Tables in MySQL. Good practice?
That sounds...horrifying.
Mar
1
comment Adding columns to production tables
Did you mean "doesn't" require adding data to the rows in your second line?
Feb
27
awarded  Outspoken
Feb
27
comment Speed up INSERTs
Your bottlenecks on the laptop are probably very different (and variable!) compared to a proper server. If you're going to stress test at least run it on a device set up as a server with nothing else running. You're likely to hit RAM/CPU bottlenecks on a laptop that might not exist on a production machine
Feb
23
accepted Why is IDENTITY_INSERT ON only allowed on one table at a time?
Feb
23
accepted Does ORDER BY on a clustered key effect performance?
Feb
14
awarded  Nice Question
Feb
13
comment Single Identity column and composite key, which to make primary?
I agree with this generally, but as JNK points out I really don't need my surrogate key to even be a key (as long as I don't fudge the uniqueness).
Feb
12
comment Why is IDENTITY_INSERT ON only allowed on one table at a time?
@AaronBertrand But again, the duplicate ID risk is exactly the same on any table with IDENTITY INSERT on, why the hard limit? I think the fact that it persists only for the connection makes much more sense as a precaution.