2,209 reputation
619
bio website
location Indianapolis, IN
age 31
visits member for 3 years, 8 months
seen 21 hours ago

Jan
13
awarded  Nice Answer
Jan
10
awarded  Yearling
Jun
27
awarded  sql-server
May
16
comment DELETE vs TRUNCATE
+1 Great answer.
May
14
awarded  Caucus
Feb
7
reviewed Needs Improvement How do Availability Groups work with cheduled jobs and SSIS packages?
Feb
7
reviewed Satisfactory Recovery time effects of Availability Groups
Feb
7
reviewed Satisfactory Is there a way to speed up an ALTER statement in SQL Server
Feb
7
awarded  Custodian
Feb
7
reviewed Satisfactory Incredibly slow query performance
Jan
10
awarded  Yearling
Dec
28
comment How much do foreign keys affect performance?
It is important to note that foreign keys can only be used in this capacity if they are trusted. Meaning, if the foreign key was created or enabled with the WITH CHECK clause, and the check was successful. The NOT FOR REPLICATION clause will also render foreign keys "untrusted" on the subscriber side.
Nov
17
revised Does varchar size matter in temporary tables?
deleted 190 characters in body
Nov
17
comment Does varchar size matter in temporary tables?
@AaronBertrand You are absolutely correct. This was a misconception on my part. I have altered my answer to reflect this. Thanks!
Nov
16
answered Does varchar size matter in temporary tables?
Nov
14
comment How define select, if bridge pair may have 3 players?
+1 for mentioning that the preferable way to perform this is outside of T-SQL. For kicks, I compared the execution plans of our two solutions, by running them in the same batch and forcing a plan recompile. I show that your query costs 73% relative to the batch, and mine costs 27%. For this small sample, this means next to nothing. However, I would be interested to see how both of our queries scale to a large data set. Good stuff!
Nov
14
answered How define select, if bridge pair may have 3 players?
Nov
8
awarded  Civic Duty
Oct
23
comment Attempt to fetch logical page (5:65424) in database 2 failed
@RemusRusanu In that case, the service could be restarted, and tempdb recreated. If there is hardware failure, however, this could potentially manifest itself later in a user database.
Oct
23
revised Attempt to fetch logical page (5:65424) in database 2 failed
added 12 characters in body